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 LAX94LA251Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Ramona, CAa failure of the pilot to maintain directional control of the airplane. A lack of total experience in tailwheel type airplanes was a factor in the accident.NTSB LAX94LA250Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Suisun City, CAundetermined.NTSB LAX94LA249Accident · Minor injuriesLimited investigationFinal reportPrue Irving Owen 160 · Jean, NVThe pilot's failure to properly connect the aileron control linkage during assembly, and his inadequate preflight which did not detect the problem before flight.NTSB LAX94LA248Accident · Serious injuriesLimited investigationFinal reportCessna 180H · Wickenburg, AZthe pilot's failure to remove the control lock prior to flight.NTSB LAX94LA247Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Bakersfield, CAThe in-flight fire due to the spontaneous combustion of sulfur dust and subsequent forced landing. A factor was the high temperature.NTSB LAX94LA246Accident · 1 fatalLimited investigationFinal reportMcCulloch J-2 · Willits, CAa loss of engine power for undetermined reasons.NTSB CHI94LA199Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Clear Lake, MNthe private pilot's failure to maintain directional control during the landing roll. Related factors are the rough/uneven terrain, and excessive brake application.NTSB CHI94LA195Accident · 1 fatalLimited investigationFinal reportCanadair T-33 · Mount Clemens, MIThe pilot's failure to maintain clearance from terrain during an aerobatic maneuver. His improper execution of the maneuver was a factor.NTSB BFO94FA096Accident · 2 fatalField investigationFinal reportCessna 210B · Culpepper, VAthe pilot's continued VFR flight into instrument meteorological conditions, which resulted in spatial disorientation and loss of control of the aircraft. Contributing factors were the low ceilings and clouds.NTSB ATL94LA119Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235C · Bainbridge, GAThe inadvertent stall by the pilot during practice agricultural spraying runs.NTSB SEA94LA147Accident · No injuriesLimited investigationFinal reportHughes 369D · Snoqualmie, WAPoor in-flight planning/decision. Factors to the accident were: clearance not maintained and tailwind.NTSB FTW94T#A03Accident · No injuriesClass 3Final reportBell 204B · Alamogordo, NMNTSB FTW94LA192Accident · Minor injuriesLimited investigationFinal reportCallair A-5T · Fabens, TXLoss of engine power for undetermined reason(s).NTSB FTW94FA191Accident · 1 fatalField investigationFinal reportPiper PA-25-235 · Breckenridge, TXThe pilot's continued VFR flight into IMC. Factors were the weather and the lack of flight instruments.NTSB CHI94T#A04Accident · No injuriesFinal reportBell 47G3B1 · Medina, MNNTSB CHI94LA196Accident · Serious injuriesLimited investigationFinal reportPopehn Arthur J. Coot A · Circle Pines, MNthe pilot-in-command's inattention to the fuel supply. Factors were the pilot-in-command's diverted attention, his not performing refueling, and rough/uneven terrain.NTSB BFO94LA095Accident · Minor injuriesLimited investigationFinal reportCessna 172 · York, PAthe loss of total engine power for undetermined reasons.NTSB ATL94LA118Accident · 1 fatalLimited investigationFinal reportMonnett Moni · Ashville, NCThe failure of the pilot to maintain control of the aircraft. A factor in the accident was the thunderstorm off the departure end of the runway.NTSB ATL94LA117Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Bainbridge, GAThe loss of engine power for undetermined reasons.NTSB SEA94LA145Accident · No injuriesLimited investigationFinal reportMooney M20C · Wamsutter, WYClearance not maintained. A factor to the accident was: transmission wire.NTSB LAX94LA255Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Dateland, AZThe pilot's inadequate preflight planning and his failure to maintain an adequate visual lookout for obstacles. Night lighting conditions and the dust were factors in the accident.NTSB LAX94LA245Accident · No injuriesLimited investigationFinal reportCessna 180J · Sedona, AZa loss of directional control due to a locked brake from a leaking hydraulic system.NTSB LAX94FA243Accident · 3 fatalField investigationFinal reportPiper PA-28-161 · Banning, CAThe failure of both pilots to see and avoid each other. The haze was a factor.NTSB FTW94LA190Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Canton, TXWas the undershoot of the runway threshold due to the pilot's failure to attain the proper touchdown point, and his failure to compensate for the wind condition. A factor was the crosswind.NTSB CHI94LA194Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Peoria, ILthe pilot's misjudged landing flare. A factor associated with the accident is the pilot allowing the airplane to descend at an excessive rate.NTSB BFO94FA092Accident · 2 fatalField investigationFinal reportCessna 172H · Millville, NJThe failure of the Cessna's pilot-in-command to perform an adequate visual lookout.NTSB SEA94LA148Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26D · North Plains, ORProper touch down point was not obtained. Factors to the accident were: canopy not secured, and inadequate preflight planning/preparation.NTSB SEA94LA142Accident · 1 fatalLimited investigationFinal report1ST FTR GP FOCKE-WULF 190 · Salt Lake City, UTImproper balancing of the ailerons resulting in aileron flutter.NTSB MIA94LA156Accident · No injuriesLimited investigationFinal reportCessna 152 · Ft. Lauderdale, FLThe pilot's improper flare and failure to maintain directional control during the aborted landing.NTSB ANC94LA067Accident · No injuriesLimited investigationFinal reportCessna 185 · Kassan Bay, AKThe pilot's inadequate compensation for the wind. Factors were the rough water and the gusty wind condition.NTSB SEA94LA141Accident · No injuriesLimited investigationFinal reportRockwell AC-690 · Casper, WYAnimals (deer) on the runway during the landing roll. Factors include a dark night.NTSB MIA94FA155Accident · 4 fatalField investigationFinal reportBeech 95-C55 · Wauchula, FLDelay by the pilot-in-command to obtain weather avoidance assistance from the ARTCC controller resulting in the inflight breakup after encounter with a thunderstorm.NTSB LAX94LA242Accident · Serious injuriesLimited investigationFinal reportHayes/Pietenpol AIR Camper · Blythe, CAThe pilot's unexpected encounter with a downdraft while flying at an improper altitude in mountainous terrain.NTSB LAX94LA241Accident · No injuriesLimited investigationFinal reportHughes 369D · Kaneohe, HIthe operator's and pilot's failure to ensure that the cargo net containing empty paper bags was sufficiently ballasted to prevent it from flying up into the tail rotor.NTSB BFO94FA091Accident · 1 fatalField investigationFinal reportMooney M20J · Edgartown, MAThe pilot's inadequate preflight inspection that failed to remove the pitot tube cover which led to loss of control of the aircraft.NTSB ATL94LA115Accident · No injuriesLimited investigationFinal reportCessna 172 · Flowery Branch, GAThe maintenance personnel's failure to properly secure the throttle linkage assembly that resulted in a reduction in engine power.NTSB ATL94FA116Accident · 1 fatalField investigationFinal reportMooney M20C · West Columbia, SCThe pilot's failure to maintain control of the airplane during climbout because of spatial disorientation. Factors were low ceilings and the dark night.NTSB SEA94LA138Accident · No injuriesLimited investigationFinal reportSiai-Marchetti SF.260B · Prospect, ORThe fracture of a connecting rod. Factors include no suitable forced landing site, and a fence and irrigation system in the field where the forced landing took place.NTSB FTW94LA187Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Carlisle, ARThe loss of engine power for undetermined reason. A factor ws the lack of suitable terrain at the pilot's disposal for the forced landing.NTSB CHI94LA190Accident · No injuriesLimited investigationFinal reportCessna 182 · Omaha, NEinadvertant VFR flight into IMC conditions and the pilot's failure to maintain directional control of the airplane. Factors related to the accident were the ground fog and rough terrain encountered.NTSB BFO94FA112Accident · 2 fatalField investigationFinal reportBeech 24R · Nantucket, MAthe total loss of engine power over unsuitable terrain, for undetermined reasons. The pilot's failure to ensure that proper survival equipment was onboard the airplane was a related factor.NTSB ANC94LA068Accident · No injuriesLimited investigationFinal reportMaule M6-235 · Bethel, AKThe pilot's failure to maintain directional control during landing.NTSB ANC94LA065Accident · No injuriesLimited investigationFinal reportTaylorcraft F-19 · Wassila-Cheri, AKCarburetor ice collecting in the carburetor throat and the pilot's failure to use carburetor heat during the extended water taxi.NTSB SEA94LA140Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Culbertson, MTThe pilot's failure to maintain directional control. Factors include gusty crosswinds, and a fence near the point of takeoff.NTSB SEA94LA137Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Sweet Home, ORThe pilot delayed using carburetor heat until the engine had already lost power due to ice forming in the carburetor throat. Factors include carburetor icing conditions, and rough/uneven terrain in the field where the forced landing was made.NTSB LAX94LA244Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8 · Acton, CAthe pilot's improper in-flight planning and his misjudging the wind speed information. Contributing factors were the gusty winds and the lack of suitable terrain.NTSB LAX94LA239Accident · No injuriesLimited investigationFinal reportEnstrom 280C · California City, CAthe pilot's inadequate compensation for the gusty wind conditions and his subsequent failure to maintain control of the helicopter.NTSB FTW94LA197Accident · No injuriesLimited investigationFinal reportGlasflugel Standard Libelle · Wellington, COWas the pilot's improper compensation for the crosswind. A factor was the crosswind.NTSB FTW94LA196Accident · No injuriesLimited investigationFinal reportBurkhart Grob G 103 Twin II · Wellington, COThe pilot's improper spoiler extension and flare.NTSB CHI94LA193Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Levant, KSThe pilot's inadequate evaluation of weather conditions associated with known thunderstorm activity. Factors were the thunderstorm and downdrafts.