NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases, newest first
Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1 ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"
Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB SEA91LA090Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Auburn, WAAn improper fuel selector valve handle, improper selection of the fuel selector position, and the pilot's lack of understanding of the fuel selector position.NTSB SEA91FA089Accident · 2 fatalField investigationFinal reportCessna 150L · Mount Vernon, WAThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall/spin at low altitude. His lack of experience was a related factor.NTSB NYC91DNA02Accident · Minor injuriesFinal reportBell 47-G3B1 · Harwich, MAA failure of the clutch during takeoff due to improper maintenance procedures. Factors related to the accident were insufficient altitude to establish an autorotation.NTSB LAX91LA182Accident · Serious injuriesLimited investigationFinal reportRobinson R22-BETA · Phoenix, AZThe pilot's failure to maintain main rotor RPM. Factor contributing to the accident was the pilot's inadequate in-flight planning.NTSB FTW91LA069Accident · No injuriesLimited investigationFinal reportCessna 172L · Huntsville, TXThe pilot's failure to maintain directional control of the airplane. A factor was the emphasis placed upon full-stall landings by his instructor.NTSB CHI91LA136Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Grayslake, ILThe instructor's inadequate compensation for wind conditions. Factors were the wind gusts and the instructor's failure to maintain airspeed.NTSB CHI91DCJ02Accident · No injuriesFinal reportFagerberg Longeze · Wahoo, NEThe improper installation/maintenance of the carburetor heat control. A factor was the pilot's restricted visual outlook.NTSB ATL91LA086Accident · No injuriesLimited investigationFinal reportCessna 182B · Elberta, ALThe pilot's failure to apply carburetor heat. Factors were weather conditions for the formation of induction ice, and the soft terrain.NTSB ATL91LA085Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Bessemer, ALRupture of a high-time, rubber, oil cooler hose, which resulted in a loss of engine oil, oil exhaustion, and seizure of the engine.NTSB ATL91FA084Accident · 2 fatalField investigationFinal reportCessna 172N · Dunlap, TNThe pilot-in-command's inadequate preflight planning/preparation, his attempted VFR flight into IFR conditions, and his subsequent failure to maintain a proper altitude. Factors in the accident were: the mountainous terrain, the foggy, low ceiling conditions…NTSB SEA91LA088Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Clark Fork, IDThe pilot-in-command's failure to maintain proper altitude in cruise light resulting in an in flight collision with a wire and subsequent forced landing in a river.NTSB NYC91LA119Accident · No injuriesLimited investigationFinal reportCessna 172M · Bloomvale, NYThe pilot's delay in aborting the takeoff.NTSB LAX91LA180Accident · Serious injuriesLimited investigationFinal reportTownsend Executive · Redding, CAThe failure of the pilot to maintain control of the helicopter. A factor in the accident was the pilot's lack of total experience in helicopters.NTSB DEN91LA062Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Santa Rosa, NMThe pilot of the other aircraft failed to maintain clearance between the aircraft.NTSB DEN91FA061Accident · Serious injuriesField investigationFinal reportCessna T210M · Littleton, COImproper reassembly of the overhauled turbocharger by maintenance personnel, and the pilot's improper use of the mixture control and boost pump. Factors related to the accident were: the adverse weather conditions and unsuitable terrain in the emergency…NTSB CHI91DER03Accident · 1 fatalFinal reportVarieze 001 · Superior, WIThe pilot's poor planning and decision making which resulted in a loss of engine power due to fuel exhaustion.NTSB ATL91LA083Accident · Minor injuriesLimited investigationFinal reportCessna 150J · New Bern, NCThe aircraft engine loss of power for an undetermined reason. Factors related to the accident were the dark night, and the inadvertent stall of the aircraft.NTSB NYC91LA118Accident · No injuriesLimited investigationFinal reportCessna P210 · Olean, NYImproper flare by the pilot, which resulted in a hard landing. Factors related to the accident were: the pilot's lack of recent experience and the unfavorable wind condition.NTSB CHI91DEM04Accident · No injuriesFinal reportFred B. Stencel Falcon X P · St. Charles, MIA result of the pilot in command not maintaining directional control during the go around maneuver. Factors associated with the accident were the pilot in command's lack of total experience and familiarity with the airplane.NTSB CHI91DEE04Accident · No injuriesFinal reportBeech 35-A33 · Vernon Hills, ILWater contamination of the fuel, and the pilot's inadequate preflight inspection.NTSB SEA91LA086Accident · No injuriesLimited investigationFinal reportGrumman G-21A · Spokane, WAThe pilot-in-command did not maintain directional control of the airplane. Factors were: the pic's inadequate compensate for the wind, his limited flight expereince in this type of airplane, and the check airman's poor supervision.NTSB FTW91LA068Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Port Lavaca, TXThe pilot's inadvertent stall at an altitude too low for recovery. A factor was the pilot's low pass.NTSB CHI91DCG02Accident · Serious injuriesFinal reportHuff Pulsar · Missouri City, MOOil fouled spark plugs resulting in a partial loss of engine power. Soft terrain in the forced landing area was a factor.NTSB SEA91LA087Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Coeur D'Alene, IDThe pilot's misjudgement of his aircraft's climb capability when flying towards rising terrain. Factors include his lack of familiarity with the geographic area.NTSB NYC91LA117Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Whitefield, NHInadequate compensation for wind conditions by the pilot which resulted in a loss of directional control. A factor contributing to the accident was the gusty wind conditions.NTSB MIA91FA124Accident · Serious injuriesField investigationFinal reportCessna 152 · Oak Meadows, FLThe failure of the instructor pilot to maintain an airspeed above stall speed resulting in an inadvertent stall at an altitude that precluded recovery. Contributing to the accident was the instructor pilot's poor judgement and ostentatious display at a low…NTSB MIA91FA123Accident · 3 fatalField investigationFinal reportWaco ASO · Lake Apopka, FLAn inadvertent stall and spin at an altitude that precluded recovery.NTSB LAX91LA175Accident · Serious injuriesLimited investigationFinal reportSnider RV6 · Paulden, AZThe pilot's poor preflight preparation and his failure to ensure that the fuel selector was properly positioned for flight.NTSB FTW91LA067Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Carlisle, ARThe pilot's failure to maintain airspeed above the stalling speed of the airplane and the resultant inadvertent stall. A factor was the emotional state of the pilot.NTSB FTW91LA066Accident · 2 fatalLimited investigationFinal reportAeronca 7AC · Bradley, ARThe pilot's attempted to perform aerobatic flight at an altitude inadequate for recovery.NTSB CHI91LA134Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Grand Forks, NDInadequate visual outlook by the pilot in command.NTSB SEA91LA260Accident · 1 fatalLimited investigationFinal reportAero Commander S-2R · Grangeville, IDThe improper decision by the pilot to continue VFR flight in IMC weather conditions in mountainous terrain, resulting in pilot disorientation and inadvertent flight into a box canyon. Factors relating to the accident were the rain showers and low ceiling…NTSB MIA91LA122Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Clewiston, FLDisintegration of the impeller for undetermined reasons resulting in the total loss of engine power necessitating the forced landing.NTSB LAX91LA179Accident · Serious injuriesLimited investigationFinal reportRobinson R-22B · Piru, CA1) The pilot failing to maintain visual lookout, and 2) inflight collision with unmarked transmission wires.NTSB LAX91LA178Accident · Serious injuriesLimited investigationFinal reportPiper PA22-150 · Las Vegas, NVThat the pilot improperly selected the fuel tank that did not contain any fuel and his subsequent failure to maintain airspeed.NTSB FTW91LA065Accident · No injuriesLimited investigationFinal reportCessna 172N · Weatherford, OKThe inadvertent stalling of the airplane. A factor was the gusty wind.NTSB CHI91LA133Accident · No injuriesLimited investigationFinal reportCessna TR182 · Jackson, MIFailure to the pilot to assure gear extension. Factors related to the accident were the electrical failure due to a seized alternator and diverted attention by the pilot.NTSB NYC91LA113Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5A · Pleasant Valley, NYThe failure of the pilot of N5232K to maintain visual contact and separation with N9763U.NTSB LAX91LA176Accident · Serious injuriesLimited investigationFinal reportGrumman AA-LC · Inyokern, CAPoor flight planning by the pilot-in-command which resulted in a total loss of engine power due to fuel exhaustion.NTSB SEA91LA085Accident · No injuriesLimited investigationFinal reportPiper PA-18-125 · Ekalaka, MTThe pilot did not maintain directional control of the airplane during the landing roll. Factors to the accident were: the landing surface was covered with slush, snow was falling and obscured the pilot's vision.NTSB SEA91LA084Accident · No injuriesLimited investigationFinal reportCessna C-172N · Ellensburg, WAThe improper maintenance inspection of the airccraft. A factor relating to the accident was a ditch in the ladning area.NTSB NYC91FA112Accident · 1 fatalField investigationFinal reportPiper PA-30 · Hollidaysburg, PAThe pilot's loss of control for undetermined reasons.NTSB ATL91LA081Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Whiteville, NCCarburetor ice due to the pilot's failure to use carburetor heat.NTSB ATL91LA080Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Saluda, SCThe flight instructor did not maintain the proper altitude during the simulated forced landing.NTSB ANC91LA053Accident · No injuriesLimited investigationFinal reportCessna 172 · Cantwell, AKThe pilot in command's poor preflight planning/preparation. A factor in the accident was the snow covered runway.NTSB SEA91LA083Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Port Orchard, WAThe loss of engine power due to contaminated fuel system.NTSB NYC91LA114Accident · No injuriesLimited investigationFinal reportCessna 150L · Montgomery, NYThe pilot's inadvertent exit (falling) from the airplane, while attempting to recover an object from outside the airplane without setting the parking brake and/or shutting down the engine.NTSB LAX91LA174Accident · No injuriesLimited investigationFinal reportCessna 182B · Madera, CAThat the pilot's fuel consumption calculation were inaccurate. Contributing to this accident was fuel exhaustion.NTSB CHI91LA132Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Fibre, MIThe pilot attempting to taxi on unsuitable terrain.NTSB CHI91LA131Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Grand Ledge, MIThe student's failure to maintain a proper altitude and clearance from the terrain along with the cfi's failure to adequately supervise the student's actions. A factor contributing to the accident was the inadequate visual lookout available due to the night…