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.

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.Jun 11, 1994 · N2927N · Substantial damageNTSB LAX94LA250Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Suisun City, CAundetermined.Jun 11, 1994 · N7112T · DestroyedNTSB 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.Jun 11, 1994 · N90614 · DestroyedNTSB LAX94LA248Accident · Serious injuriesLimited investigationFinal reportCessna 180H · Wickenburg, AZthe pilot's failure to remove the control lock prior to flight.Jun 11, 1994 · N4764U · Substantial damageNTSB 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.Jun 11, 1994 · N8507H · Substantial damageNTSB LAX94LA246Accident · 1 fatalLimited investigationFinal reportMcCulloch J-2 · Willits, CAa loss of engine power for undetermined reasons.Jun 11, 1994 · N22GR · DestroyedNTSB 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.Jun 11, 1994 · N83019 · Substantial damageNTSB 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.Jun 11, 1994 · N12418 · DestroyedNTSB 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.Jun 11, 1994 · N210M · DestroyedNTSB ATL94LA119Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235C · Bainbridge, GAThe inadvertent stall by the pilot during practice agricultural spraying runs.Jun 11, 1994 · N4643Y · Substantial damageNTSB SEA94LA147Accident · No injuriesLimited investigationFinal reportHughes 369D · Snoqualmie, WAPoor in-flight planning/decision. Factors to the accident were: clearance not maintained and tailwind.Jun 10, 1994 · N1088G · Substantial damageNTSB FTW94T#A03Accident · No injuriesClass 3Final reportBell 204B · Alamogordo, NMJun 10, 1994 · N109CH · Substantial damageNTSB FTW94LA192Accident · Minor injuriesLimited investigationFinal reportCallair A-5T · Fabens, TXLoss of engine power for undetermined reason(s).Jun 10, 1994 · N96084 · Substantial damageNTSB 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.Jun 10, 1994 · N4492Y · DestroyedNTSB CHI94T#A04Accident · No injuriesFinal reportBell 47G3B1 · Medina, MNJun 10, 1994 · N73998 · Substantial damageNTSB 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.Jun 10, 1994 · N123AP · Substantial damageNTSB BFO94LA095Accident · Minor injuriesLimited investigationFinal reportCessna 172 · York, PAthe loss of total engine power for undetermined reasons.Jun 10, 1994 · N5522R · Substantial damageNTSB 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.Jun 10, 1994 · N112MX · Substantial damageNTSB ATL94LA117Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Bainbridge, GAThe loss of engine power for undetermined reasons.Jun 10, 1994 · N89972 · Substantial damageNTSB SEA94LA145Accident · No injuriesLimited investigationFinal reportMooney M20C · Wamsutter, WYClearance not maintained. A factor to the accident was: transmission wire.Jun 9, 1994 · N711LP · Substantial damageNTSB 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.Jun 9, 1994 · N3629P · DestroyedNTSB LAX94LA245Accident · No injuriesLimited investigationFinal reportCessna 180J · Sedona, AZa loss of directional control due to a locked brake from a leaking hydraulic system.Jun 9, 1994 · N180DK · Substantial damageNTSB 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.Jun 9, 1994 · N4512Z · 2 aircraft · DestroyedNTSB 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.Jun 9, 1994 · N5632P · DestroyedNTSB 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.Jun 9, 1994 · N72009 · Substantial damageNTSB BFO94FA092Accident · 2 fatalField investigationFinal reportCessna 172H · Millville, NJThe failure of the Cessna's pilot-in-command to perform an adequate visual lookout.Jun 9, 1994 · N4964R · 2 aircraft · DestroyedNTSB 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.Jun 8, 1994 · N7751S · Substantial damageNTSB SEA94LA142Accident · 1 fatalLimited investigationFinal report1ST FTR GP FOCKE-WULF 190 · Salt Lake City, UTImproper balancing of the ailerons resulting in aileron flutter.Jun 8, 1994 · N25074 · DestroyedNTSB MIA94LA156Accident · No injuriesLimited investigationFinal reportCessna 152 · Ft. Lauderdale, FLThe pilot's improper flare and failure to maintain directional control during the aborted landing.Jun 8, 1994 · N6159Q · Substantial damageNTSB 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.Jun 8, 1994 · N4471R · Substantial damageNTSB SEA94LA141Accident · No injuriesLimited investigationFinal reportRockwell AC-690 · Casper, WYAnimals (deer) on the runway during the landing roll. Factors include a dark night.Jun 7, 1994 · N265JH · Substantial damageNTSB 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.Jun 7, 1994 · N966N · DestroyedNTSB 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.Jun 7, 1994 · N76TC · DestroyedNTSB 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.Jun 7, 1994 · N4943T · Substantial damageNTSB 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.Jun 7, 1994 · N4393H · DestroyedNTSB 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.Jun 7, 1994 · N3882L · Substantial damageNTSB 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.Jun 7, 1994 · N6879U · DestroyedNTSB 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.Jun 6, 1994 · N943TA · Substantial damageNTSB 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.Jun 6, 1994 · N8363K · DestroyedNTSB 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.Jun 6, 1994 · N5380N · Substantial damageNTSB 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.Jun 6, 1994 · N9258S · DestroyedNTSB ANC94LA068Accident · No injuriesLimited investigationFinal reportMaule M6-235 · Bethel, AKThe pilot's failure to maintain directional control during landing.Jun 6, 1994 · N56447 · Substantial damageNTSB 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.Jun 6, 1994 · N96330 · Substantial damageNTSB 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.Jun 5, 1994 · N4509Y · Substantial damageNTSB 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.Jun 5, 1994 · N9271T · Substantial damageNTSB 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.Jun 5, 1994 · N9084D · Substantial damageNTSB 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.Jun 5, 1994 · N123MT · Substantial damageNTSB FTW94LA197Accident · No injuriesLimited investigationFinal reportGlasflugel Standard Libelle · Wellington, COWas the pilot's improper compensation for the crosswind. A factor was the crosswind.Jun 5, 1994 · N3992 · Substantial damageNTSB FTW94LA196Accident · No injuriesLimited investigationFinal reportBurkhart Grob G 103 Twin II · Wellington, COThe pilot's improper spoiler extension and flare.Jun 5, 1994 · N5462N · Substantial damageNTSB 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.Jun 5, 1994 · N2344T · Destroyed