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 MIA94WA145Accident · No injuriesForeign investigationPiper PA-31-350 · Herrera, Dominican RepublicNTSB FTW94LA166Accident · No injuriesLimited investigationFinal reportBell 47G · Sulphur, OKThe loss of engine power due to the failure of an engine accessory oil pump gear. A factor was the lack of suitable terrain for the autorotation.NTSB FTW94FA165Accident · 2 fatalField investigationFinal reportCessna 340 · Elko, NVThe pilot's continued flight into instrument meteorological conditions (IMC), and his failure to maintain altitude (or clearance) from mountainous terrain. Factors related to the accident were: the adverse weather conditions, high (mountainous/hilly) terrain,…NTSB SEA94LA119Accident · 1 fatalLimited investigationFinal reportHallstrom BD-5B · St. George, UTCarburetor contamination and low output, and the pilot's improper decision to attempt to continue the approach. A factor was the pilot's lack of recent flight experience.NTSB NYC94LA083Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Lewisburg, WVThe pilot's inadequate inflight decision, inadvertent VFR flight into IMC, and failure to maintain adequate terrain clearance which resulted in inflight collision with trees. A factor was inadequate altitude.NTSB NYC94FA082Accident · 2 fatalField investigationFinal reportMooney M20K · Swanton, OHFailure of an engine cylinder which resulted in the loss of engine power and the pilot's failure to establish the proper descent path to an airport that was within the glide distance of the airplane. A factor was the overgross weight condition of the airplane.NTSB MIA94LA143Accident · Minor injuriesLimited investigationFinal reportAerosport Scamp WT-B1 · Lake Wales, FLThe pilot-in-command's failure to maintain airspeed (vs) while maneuvering resulting in an in-flight loss of control (inadvertent stall) and subsequent in-flight collision with terrain.NTSB FTW94LA164Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Monticello, ARThe loss of engine power due to the number 2 cylinder cracking. A factor was the lack of suitable terrain for the forced landing.NTSB FTW94LA162Accident · No injuriesLimited investigationFinal reportRockwell 112A · Henderson, NVThe partial loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW94LA160Accident · No injuriesLimited investigationFinal reportCessna 150M · Spring, TXThe pilot's failure to maintain directional control during the attempted takeoff from the touch and go landing. Factors were the inadvertent porpoise and the soft terrain.NTSB LAX94LA219Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Arvin, CAa fatigue failure of the crankshaft gear teeth.NTSB FTW94LA163Accident · No injuriesLimited investigationFinal reportGulfstream G-164C · Weiner, ARThe pilot selected unsuitable terrain for the takeoff.NTSB FTW94LA159Accident · No injuriesLimited investigationFinal reportAyres S2R-G6 · De Witt, ARA stall/mush into terrain after the pilot inadvertently raised the flaps.NTSB FTW94FA158Accident · 1 fatalField investigationFinal reportBell 47G-2 · Tulsa, OKIn flight loss of control due to the pilot's improper use of the cyclic and collective controls when he maneuvered abruptly to avoid colliding with a flock of birds. Factors were the birds and the inflight separation of the left synchronized elevator.NTSB CHI94LA163Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Kettle River, MNThe pilot's improper use of carburetor heat and the lack of suitable terrain for a forced landing. The carburetor icing weather condition was a factor.NTSB ATL94LA101Accident · No injuriesLimited investigationFinal reportCessna 152 · Andrews, SCThe failure of the pilot to maintain directional control of the aircraft.NTSB ATL94LA100Accident · Serious injuriesLimited investigationFinal reportSchweizer 269C · Hiram, GAThe inadvertent flight from VMC conditions to IMC conditions by the pilot. A factor in the accident was the ground fog in the area.NTSB NYC94LA081Accident · No injuriesLimited investigationFinal reportLet Super Blanik L-33 · New Castle, VAThe pilot's improper use of the flight controls resulting in failure to maintain a proper descent rate during the approach for landing. A factor in this accident was the pilot's lack of total experience in this type of glider.NTSB NYC94LA080Accident · No injuriesLimited investigationFinal reportDavis DK-1 · East Haddam, CTThe pilot's failure to maintain the proper glidepath during landing approach.NTSB MIA94FA141Accident · 1 fatalField investigationFinal reportBeech 95-55 · New Port Richey, FLThe pilot's feathering of the wrong propeller after an engine failure for undetermined reason(s).NTSB FTW94LA157Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · San Antonio, TXThe pilot continued flight into known adverse weather. The thunderstorm activity was a factor.NTSB CHI94LA158Accident · Minor injuriesLimited investigationFinal reportAeronca 11AC · Montello, WIthe pilot's inadequate compensation for the wind conditions. A factor related to the accident was the crosswind.NTSB ATL94FA099Accident · Serious injuriesField investigationFinal reportBeech 58 · Monroe, NCThe pilot's inadequate pre-flight inspection.NTSB MIA94T#A03Accident · No injuriesClass 3Final reportHughes 269A · Aripeka, FLNTSB MIA94LA140Accident · Minor injuriesLimited investigationFinal reportLuscombe 8E · Deland, FLCorrosion and subsequent failure of the left main landing gear strut.NTSB MIA94LA139Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Fernandina, FLThe pilot in command's improper use of flight controls and his failure to maintain airspeed resulting in an inadvertent stall and uncontrolled descent to ground impact.NTSB FTW94LA161Accident · No injuriesLimited investigationFinal reportCessna 150J · Del Rio, TXFuel exhaustion induced power loss due to the pilot's inaccurate fuel consumption calculations. The lack of suitable terrain for the forced landing was a factor.NTSB FTW94FA156Accident · 2 fatalField investigationFinal reportBoeing E75N1 · Peyton, COThe pilot's performance of aerobatic maneuvers at an altitude inadequate for recovery.NTSB CHI94LA160Accident · No injuriesLimited investigationFinal reportCessna 175 · Plainfield, ILfuel contamination (water), and inadequate aircraft preflight inspection.NTSB CHI94LA159Accident · Serious injuriesLimited investigationFinal reportCessna T210M · Burlington, IAfuel exhaustion resulting from the failure of the pilot to refuel en route.NTSB CHI94FA157Accident · 4 fatalField investigationFinal reportBellanca 17-30A · Camdenton, MOThe pilot's failure to maintain control of the aircraft. A factor was his lack of experience flying in actual instrument flight conditions.NTSB SEA94LA118Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Columbia, CAThe pilot in command's failure to maintain directional control. The crosswind was a factor.NTSB NYC94LA079Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Hempstead, NYThe inadvertent collision with a hidden obstruction after swerving to avoid birds during a water takeoff.NTSB MIA94LA138Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Belleair, FLImproper maintenance inspection of the crankcase breather tube resulting in failure to detect blockage of the tube.NTSB MIA94LA137Accident · Serious injuriesLimited investigationFinal reportRichmond Rotorway Executive · Ormond Beach, FLThe pilot in command's improper autorotation following partial loss of engine power which resulted in an inflight collision with a fence prior to ground touchdown.NTSB FTW94FA155Accident · 2 fatalField investigationFinal reportCessna 172P · Arlington, TXThe pilot's loss of aircraft control for an undetermined reason, while maneuvering in the vicinity of the airport.NTSB ATL94LA098Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7-B · Burlington, NCInadvertent burner control interference by the passenger. A factor was the presence of electric transmission wires at the forced landing site.NTSB SEA94LA117Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Yuba City, CAAn inadvertent stall/mush after takeoff. The over-weight loading of the aircraft was a factor.NTSB LAX94FA217Accident · 2 fatalField investigationFinal reportMooney M20K · Ventura, CAFailure of the flight crew to maintain control of the airplane in instrument meteorological conditions (IMC), due to spatial disorientation. A factor related to the accident was: the first pilot's overconfidence in his ability to assure control of the…NTSB FTW94IA154Incident · No injuriesIncident investigationFinal reportSaab-Scania SF-34OB · Texarkana, ARThe pilot's inability to retard the power levers during a rejected takeoff due to his failure to perform the emergency procedures in accordance with the aircraft operating manual. A factor was the illumination of the configuration light as result of…NTSB CHI94LA161Accident · No injuriesLimited investigationFinal reportBell 206B · Winnebago, ILa wire strike due to failure to maintain proper altitude, and improper visual lookout by the pilot-in-command.NTSB CHI94LA156Accident · No injuriesLimited investigationFinal reportCessna 150F · Chippewa Falls, WIthe loss of engine power due to a binding carburetor heat door.NTSB LAX94FA214Accident · 2 fatalField investigationFinal reportRobinson R-22 · Hacienda Height, CAThe pilot's selection of an en route cruise altitude which provided insufficient obstruction clearance, and his inadequate visual lookout. Factors in the night time accident were the reduced visibility as a result of the fog and haze.NTSB FTW94LA153Accident · No injuriesLimited investigationFinal reportCessna 120 · Goodyear, AZThe pilot's failure to maintain directional control. A factor was the gusty crosswind.NTSB CHI94LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Anthony, KSthe pilot's failure to obtain sufficient airspeed prior to liftoff. A factor in the accident was the pilot's lack of total experience in type of airplane.NTSB MIA94WA136Accident · 4 fatalForeign investigationBeech BE65-A80 · Moca, Dominican RepublicNTSB MIA94LA135Accident · No injuriesLimited investigationFinal reportBeech A35 · St. Petersburg, FLFailure of the pilot-in-command to maintain airspeed and proper glidepath resulting in the in-flight collision with trees short of the airport property.NTSB FTW94FA152Accident · 5 fatalField investigationFinal reportBell 206L-3 · Intracoastl Cty, LAThe pilot's failure to maintain aircraft control for undetermined reasons.NTSB CHI94LA153Accident · No injuriesLimited investigationFinal reportMaule M-4 · Salina, KSFailure of the pilot to maintain directional control, which resulted in an inadvertent ground loop/swerve. Factors related to the accident were: the crosswind, and the pilot's lack of experience in the make and model of aircraft.NTSB ATL94LA095Accident · Serious injuriesLimited investigationFinal reportSchweizer 300C · Randleman, NCThe pilot's failure to adequately preflight the helicopter which resulted in a complete loss of engine power. A factor was water in the fuel supply.