NTSB investigations
180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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 WPR11LA218Accident · No injuriesLimited investigationFinal reportPiper PA46-500TP · Rock Springs, WYThe overstress fracture of the right aileron midspan hinge bracket due to modal vibrations created by a deflated right main landing gear tire during the takeoff roll.NTSB ERA11LA278Accident · No injuriesLimited investigationFinal reportAerospatiale AS350B2 · Camden, SCThe instructor pilot did not maintain adequate helicopter control while maneuvering, which resulted in a hard landing.NTSB ERA11CA284Accident · No injuriesData collectionFinal reportCessna 172P · Stuart, FLThe student pilot's improper landing flare, which resulted in a hard landing.NTSB ERA11CA283Accident · No injuriesData collectionFinal reportCessna 172P · Fort Pierce, FLThe student pilot's improper flare, which resulted in a hard landing.NTSB ERA11CA281Accident · Minor injuriesData collectionFinal reportLuscombe 8E · Apex, NCThe pilot’s excessive application of the brakes, which caused the airplane to nose over.NTSB ERA11CA277Accident · No injuriesData collectionFinal reportCessna A185F · Ocean City, NJThe pilot's failure to maintain directional control during the takeoff roll.NTSB CEN11LA318Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Yancey, TXThe loss of engine power due to the unintentional closure of the fuel shutoff valve.NTSB CEN11LA317Accident · No injuriesLimited investigationFinal reportTexas Helicopter OH-13E/M74 · New Columbia, ILThe pilot's failure to maintain adequate clearance from the wheat crop during takeoff.NTSB CEN11LA316Accident · 1 fatalLimited investigationFinal reportNorris Dominator · Blue Springs, NEThe pilot's failure to maintain clearance from power lines.NTSB WPR11IA213Incident · No injuriesIncident investigationFinal reportCessna 421B · Truckee, CAFatigue failure of the right flap extend cable during the landing approach.NTSB ERA11FA274Accident · 1 fatalField investigationFinal reportBeech E18S · Miami Gardens, FLThe pilot’s improper response to a loss of power in the No. 2 engine and his failure to ensure that the airplane was airworthy. Contributing to the accident was the inadequate engine maintenance by the operator's maintenance personnel.NTSB CEN11CA314Accident · No injuriesData collectionFinal reportPrichard Kevin Legacy 2K · Kansas City, MOThe pilot's misjudgment of the landing area, which resulted in the airplane touching down on a grass area adjacent to the runway and between parallel taxiways.NTSB WPR11LA216Accident · No injuriesLimited investigationFinal reportDralle RV-8 · Livermore, CAThe pilot's decision to exit the runway while still traveling at an excessive speed and his subsequent loss of directional control.NTSB ERA11FA272Accident · 1 fatalField investigationFinal reportRobinson Helicopter R44 II · Indiana, PAThe pilot's operation of the helicopter at a low-forward airspeed out of ground effect, which resulted in the helicopter’s loss of translational lift and tail rotor authority and the pilot’s subsequent loss of helicopter control.NTSB ERA11CA303Accident · No injuriesData collectionFinal reportChampion 7EC-703 · Moultonboro, NHThe pilot’s loss of directional control during the landing rollout, which resulted in a collision with trees.NTSB ERA11CA275Accident · No injuriesData collectionFinal reportBeech A23 · Hammonton, NJThe pilot's failure to maintain directional control during the aborted takeoff.NTSB CEN11FA312Accident · 1 fatalField investigationFinal reportCombs Earl W Kitfox Speedster · Elephant Butte, NMThe pilot's loss of control of the airplane for reasons that could not be determined because postaccident examination of the airplane did not reveal any anomalies that would have precluded normal operation.NTSB WPR11CA215Accident · No injuriesData collectionFinal reportCessna 185A · Bend, ORThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA11CA279Accident · No injuriesData collectionFinal reportFranke Harry C Avid Flyer B · Somerset, PAThe pilot’s failure to hold full power for takeoff.NTSB ERA11CA273Accident · No injuriesData collectionFinal reportCessna 172M · Suchez, GAThe failure of the pilot to initiate a go-around and his excessive airspeed on the final landing approach.NTSB ERA11CA271Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Millbrook, NYThe student pilot’s failure to maintain directional control during landing and the pilot’s inadequate remedial action, which resulted in a runway excursion.NTSB ERA11CA270Accident · No injuriesData collectionFinal reportCessna 182T · East Hampton, NYThe pilot's failure to maintain directional control while landing with a crosswind, which resulted in a runway excursion.NTSB ERA11LA290Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Albion, NYA bearing failure in the engine’s supercharger section, which resulted in a total loss of engine power during flight. Contributing to the accident was the soft soil of the forced landing site.NTSB CEN11LA315Accident · No injuriesLimited investigationFinal reportHughes 269B · Edgerton, INA loss of clearance between the tail rotor drive shaft and the tailboom bulkhead for undetermined reasons, which resulted in the overstress failure of the drive shaft.NTSB CEN11FA310Accident · 1 fatalField investigationFinal reportJurmu Stol CH701 · Pulaski, WIThe pilot did not maintain control of the airplane during initial climb, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s lack of recent flight experience.NTSB CEN11CA331Accident · Minor injuriesData collectionFinal reportCessna 172R · Fort Worth, TXThe student pilot's improper recovery from the bounced landing and the flight instructor's delayed remedial action.NTSB CEN11CA291Accident · No injuriesData collectionFinal reportCessna A185F · Hot Springs, ARThe pilot’s improper recovery from a bounced landing.NTSB ANC11WA028Accident · 1 fatalForeign investigationCessna 195A · Campbell River, CanadaNTSB WPR11LA211Accident · No injuriesLimited investigationFinal reportCessna 172 · Mesa, AZThe student pilot's inadequate directional control during the landing roll.NTSB WPR11CA212Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Chandler, AZThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN11CA321Accident · No injuriesData collectionFinal reportChang RV-10 · Minford, OHA loose fuel line fitting, which caused a fuel leak and subsequent in-flight fire.NTSB CEN11CA309Accident · No injuriesData collectionFinal reportCessna 208B · El Paso, TXThe pilot's loss of control as result of the gusting wind.NTSB ERA11WA276Accident · 2 fatalForeign investigationRobinson R22 · Sulmona, ItalyOn April 26, 2011, at 1743 coordinated universal time (1843 local time), a Robinson R22, Italian registration I-ETEC, was destroyed when it impacted power lines near Sulmona, L'Aquila, Italy. The pilot and the observer were fatally injured. The flight, which…NTSB DCA11IA047Incident · No injuriesIncident investigationFinal reportBoeing 737-7Q8 · Chicago, ILThe flight crew's delayed deployment of the speedbrakes and thrust reversers, resulting in insufficient runway remaining to bring the airplane to a stop. Contributing to the delay in deployment of these stopping devices was the flight crew's inadequate…NTSB ERA11LA266Accident · Serious injuriesLimited investigationFinal reportAirbus A330-323 · New York, NYThe flight attendant's inadvertent fall, which resulted in a serious injury.NTSB DCA11WA051Incident · No injuriesForeign investigationBoeing 737 · Stockholm, SwedenOn April 25, 2011, at 0532 UTC, a Boeing 737-800, registration EI-DAD, experienced multiple electrical problems while airborne. No injuries occurred and the airplane was not damaged. The flight was registered to and operated by Ryanair, Ltd. and was being…NTSB CEN11LA308Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Streetman, TXThe airplane’s inability to establish a climb for undetermined reasons, which resulted in a collision with trees.NTSB CEN11CA301Accident · No injuriesData collectionFinal reportAyres S2R-R1340 · Estelline, SDThe pilot's failure to maintain directional control of the airplane during takeoff.NTSB WPR11LA210Accident · No injuriesLimited investigationFinal reportCessna 150H · College Place, WAThe pilot’s delayed use of carburetor heat while operating the airplane in atmospheric conditions conducive to carburetor icing, which resulted in a total loss of engine power due to carburetor icing during final approach.NTSB WPR11CA208Accident · No injuriesData collectionFinal reportDoktor Fiberglas H101 Salto · Peoria, AZThe glider's encounter with turbulence and loss of lift, which resulted in a ditching in a lake.NTSB ERA11CA267Accident · Minor injuriesData collectionFinal reportCessna 182A · Galax, VAThe pilot's inadequate compensation for the wind while on approach for landing.NTSB ERA11CA262Accident · No injuriesData collectionFinal reportCessna U206G · Stow, MAThe pilot's inadequate compensation for the crosswind condition and his failure to maintain directional control during landing.NTSB CEN11LA307Accident · 1 fatalLimited investigationFinal reportCessna 320 · Lake Heron, NMThe pilot’s controlled flight into terrain while conducting a flight at low altitude in instrument meteorological conditions.NTSB WPR11LA209Accident · No injuriesLimited investigationFinal reportCessna 182B · Colville, WAThe partial loss of engine power during takeoff for reasons that could not be determined because postaccident examination revealed no mechanical malfunctions or failures that would have precluded normal operation.NTSB WPR11LA207Accident · No injuriesLimited investigationFinal reportDavison RV-7A · Marsing, IDA loss of engine power during initial climb for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR11CA206Accident · No injuriesData collectionFinal reportTew William P Team Rocket F1 · Heber, UTThe pilot's failure to maintain directional control during landing.NTSB ERA11LA263Accident · 1 fatalLimited investigationFinal reportSolo Wings Windlass Aquilla · Starke, FLThe pilot's loss of airplane control while taxiing, which resulted in the weight-shift-controlled airplane becoming inadvertently airborne and subsequently impacting the ground. Contributing to the accident was the pilot's lack of experience in the make and…NTSB ERA11FA258Accident · 1 fatalField investigationFinal reportCessna 210D · Altavista, VAThe pilot’s loss of airplane control due to spatial disorientation. Contributing to the accident was the pilot’s lack of experience in actual night instrument conditions.NTSB ERA11CA260Accident · Minor injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Belhaven, NCThe pilot's failure to maintain adequate clearance above crops while performing an aerial application flight.NTSB ERA11CA259Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Lake Wales, FLThe pilot’s failure to maintain directional control during the landing roll.