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 LAX04CA093Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Scottsdale, AZfailure of the pilot to maintain directional control on the takeoff roll. A factor in the accident was the pilot's failure to retract the flaps.NTSB SEA04LA033Accident · No injuriesLimited investigationFinal reportCessna 172RG · Enumclaw, WAA loss of engine power while maneuvering due to the failure of the heads of six of the eight cam followers. Factors include the pilot's decision to keep the gear retracted during the forced landing, and the rough/uneven terrain.NTSB ATL04LA066Accident · Minor injuriesLimited investigationFinal reportCurrent Kitfox 313 · Selma, ALThe pilot's inadequate installation, and his failure to secure the main fuel line, which resulted in fuel starvation.NTSB LAX04LA092Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Vacaville, CAthe pilot's failure to either obtain a preflight weather report and forecast for the destination or to add additional fuel, which ultimately resulted in fuel exhaustion and collision with trees.NTSB FTW04LA060Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Encino, TXThe pilot's failure to maintain clearance from a tree while hovering.NTSB DEN04FA038Accident · 2 fatalField investigationFinal reportBeech B95 · Cedar City, UTthe pilot in command's (examinee) failure to maintain airspeed which resulted in a stall. Contributing to the accident was the inadequate supervision by the designated examiner.NTSB LAX04CA099Accident · No injuriesData collectionFinal reportCessna 152 · San Diego, CAthe pilot's misjudgment of clearance from the vehicle while taxiing. A factor in the accident was the pilot's diverted attention.NTSB FTW04WA154Accident · No injuriesForeign investigationMooney M20C · Mazamitla, MexicoNTSB DEN04LA037Accident · No injuriesLimited investigationFinal reportAerotek Pitts Special S-1S · Crawford, COthe pilot's failure to maintain directional control and his failure to maintain clearance from the snow bank during the landing. A factor contributing to the accident was the snow bank.NTSB CHI04LA054Accident · No injuriesLimited investigationFinal reportCessna 150E · Princeton, MOThe encounter with the unknown snow drifts during landing. The factors were the snow drifts, night, and the airport's failure to issue a NOTAM on the runway conditions.NTSB CHI04FA055Accident · 2 fatalField investigationFinal reportCessna 182P · Baudette, MNThe pilot's intentional flight into adverse weather conditions, and his failure to maintain adequate terrain clearance. Contributing factors were the pilot's lack of an instrument rating, low ceiling, low altitude, and the dark night conditions.NTSB ATL04LA065Accident · No injuriesLimited investigationFinal reportAero Commander 500 · Allendale, SCThe failure of the hydraulic brake system accumulator due to a ruptured diaphragm. A factor was the ditch.NTSB NYC04LA057Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Bradford, PAA total loss of engine power for undetermined reasons during approach.NTSB MIA04WA042Accident · Minor injuriesForeign investigationCessna 337 · Pastaza, EcuadorNTSB LAX04CA091Accident · No injuriesData collectionFinal reportFleet 2 · Fresno, CAthe pilot's failure to set the throttle friction lock, which resulted in the inadvertent application of the throttle, followed by a loss of directional control.NTSB IAD04LA007Accident · No injuriesLimited investigationFinal reportPiper PA-25-180 · Baltimore, MDA loss of engine power for undetermined reasons. Factors included a low ambient temperature and a lack of suitable terrain for the forced landing.NTSB FTW04LA059Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Fort Worth, TXThe pilot's failure to maintain control and the partial loss of engine power as a result of an improperly installed mixture control linkage.NTSB DEN04TA036Accident · Minor injuriesFinal reportAyres S2T-T65 · Magdalena, NMloss of engine power for reasons undetermined. A contributing factor was the lack of suitable terrain for a forced landing.NTSB DEN04LA042Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Glade Park, COthe pilot's inadequate in-flight planning/decision. Contributing factors include the pilot's selection of unsuitable terrain for landing and the snow covered terrain.NTSB CHI04LA053Accident · No injuriesLimited investigationFinal reportBeech E-90 · Galesburg, ILThe pilot's inadequate preflight by not complying with the airplane's before takeoff checklist to verify that the cabin door was secured leading to its in-flight separation from the airplane. A factor was that the door was not secured.NTSB NYC04FA056Accident · Serious injuriesField investigationFinal reportPiper PA-28-151 · Danbury, CTThe loss of engine power for undetermined reasons, and the pilot's failure to maintain adequate airspeed.NTSB LAX04LA090Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · California City, CAthe pilot's decision to continue taxiing during dark night conditions without an operable taxi/landing light or taxiway lights and his failure to maintain taxiway alignment. Contributing factors to the accident were the dark night light conditions, the failed…NTSB MIA04WA039Accident · Serious injuriesForeign investigationCessna U206G · Canaima, VenezuelaNTSB FTW04WA058Accident · No injuriesForeign investigationCessna 150L · Santo Domingo, Dominican RepublicNTSB FTW04FA057Accident · 1 fatalField investigationFinal reportCessna 182RG · El Dorado, ARThe loss of engine power as a result of loss of engine oil due to the failure of the oil filter converter plate gasket and the noncompliance to an airworthiness directive. Contributing factors were the lack of suitable terrain for the forced landing and the…NTSB ANC04LA019Accident · Minor injuriesLimited investigationFinal reportGothard Super Cuby · Palmer, AKThe loss of engine power after takeoff for an undetermined reason, which resulted in a forced landing and in-flight collision with trees.NTSB MIA04CA041Accident · No injuriesData collectionFinal reportMaule M-7-235B · Fort Lauderdale, FLThe pilot's failure to maintain aircraft control. A factor in this accident was the improper use of full flaps.NTSB LAX04LA087Accident · No injuriesLimited investigationFinal reportCessna 421C · Window Rock, AZthe pilot's failure to maintain adequate airspeed in the landing flare to compensate for airframe icing, which resulted in a premature stall and hard landing. The degraded aircraft performance due to airframe ice was a contributing factor.NTSB LAX04CA088Accident · No injuriesData collectionFinal reportPiper PA 28-181 · Groveland, CAthe pilot's inadequate visual lookout, and his failure to maintain obstacle clearance. Factors to the accident were the parked vehicle, and the pilot's diverted attention.NTSB LAX04CA086Accident · No injuriesData collectionFinal reportCessna 172F · Redlands, CAthe pilot's inadequate compensation for the existing gusty crosswind condition, and his failure to maintain directional control. Contributing factors were a crosswind and wind gusts.NTSB LAX04CA085Accident · No injuriesData collectionFinal reportCessna 172N · Hayfork, CAthe pilot's inadequate in-flight decision to attempt a landing on a snow covered runway without ascertaining the depth of the snow cover.NTSB FTW04LA056Accident · No injuriesLimited investigationFinal reportPitts S-1S · Burleson, TXThe separation of the right main gear wheel, during landing, due to the improper maintenance by unknown maintenance personnel on the right main landing gear assembly.NTSB FTW04FA055Accident · 1 fatalField investigationFinal reportMooney M20C · Amarillo, TXThe pilot's incapacitation due to chest pains, resulting in a loss of control.NTSB FTW04FA054Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · Beaumont, TXThe flight instructor's failure to maintain clearance with a static line. Contributing factors were the low cloud ceiling weather conditions and night light conditions.NTSB DEN04FA035Accident · 1 fatalField investigationFinal reportRockwell 690A · Cortez, COthe pilot's inadequate planned approach and his failure to maintain airspeed which resulted in a stall. Contributing factors were low altitude flight maneuvering in an attempt to lose excessive altitude and realign the airplane for landing, and his failure to…NTSB DCA04RA016Accident · No injuriesForeign investigationBoeing 737-300 · Sharm El Sheikh, EgyptNTSB ATL04LA063Accident · Minor injuriesLimited investigationFinal reportCessna 182G · Taylorsville, NCThe pilot's failure to follow the checklist, resulting in a loss of directional control on the takeoff roll when the seat moved rearward, and on ground collision with an embankment.NTSB SEA04FA032Accident · 4 fatalField investigationFinal reportCessna 182G · Glasgow, MTLoss of aircraft control resulting in an in-flight collision with terrain. Factors include marginal weather and dark night conditions.NTSB SEA04FA031Accident · 1 fatalField investigationFinal reportPiper PA-44-180 · Cave Junction, ORBoth the pilot-in-command and the co-pilot allowing the aircraft to enter into an area of adverse weather (icing conditions at low [-20 degrees C] temperatures) resulting in sequential induction icing, induction filter blockage, carburetor icing and the…NTSB NYC04WA055Accident · 3 fatalForeign investigationPiper PA-31T · Toussus Le Nobl, FranceNTSB CHI04LA052Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Fishers, INThe pilot not maintaining altitude/clearance from the trees during the circling approach, his continued descent below minimum descent altitude, and the pilot not performing a missed approach. A factor was the trees the pilot impacted during the circling…NTSB ANC04LA018Accident · Serious injuriesLimited investigationFinal reportPiper PA-31-350 · Koyukuk, AKThe pilot's continued flight into adverse weather conditions, and his failure to maintain clearance from terrain, which resulted in an in-flight collision with terrain. Factors associated with the accident were fog and whiteout weather conditions.NTSB LAX04LA084Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Riverside, CAengine oil exhaustion due to the extrusion of an oil filter converter plate gasket and the failure of the aircraft owner to comply with a mandatory Service Bulletin and a Federal Aviation Administration emergency Airworthiness Directive.NTSB FTW04LA053Accident · Minor injuriesLimited investigationFinal reportMooney M20R · Sheridan, ARThe loss of engine power due to fuel starvation as a result of the pilot's improper positioning of the fuel tank selector. A factor was the lack of suitable terrain for the forced landing.NTSB FTW04FA052Accident · 2 fatalField investigationFinal reportBellanca 17-30A · Dallas, TXThe failure of flight/navigation instruments while in instrument meteorological conditions (in-cloud flight and low ceilings) resulting in spatial disorientation. A contributing factors was the prevaling instrument meteorological conditions (low ceiling and…NTSB SEA04CA037Accident · No injuriesData collectionFinal reportBellanca 8KCAB · Bend, ORDirectional control not maintained during landing. Factors include an icy runway and a snow bank.NTSB MIA04WA046Accident · No injuriesForeign investigationCessna 172 · Lamentin, MartiniqueNTSB MIA04FA037Accident · 1 fatalField investigationFinal reportCessna 441 · Greenacres City, FLThe pilot's failure to maintain aircraft control, which resulted in an inadvertent stall/spin and subsequent uncontrolled descent into a canal. A factor was the pilot's impairment by the drug chlorpheniramine.NTSB LAX04LA083Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Rialto, CAThe pilot's inadequate in-flight planning/decision by his fuel mismanagement and his delay in initiating remedial action which resulted in fuel exhaustion and the loss of engine power.NTSB CHI04LA050Accident · No injuriesLimited investigationFinal reportCessna 182A · West Chicago, ILThe inadequate starting and flooded engine procedure used by certified flight instructor while providing instruction to the dual student.