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 CHI01LA081Accident · No injuriesLimited investigationFinal reportCessna 172RG · Troy, MIthe excessive touchdown airspeed and the directional control not maintained by the pilot. The snow bank was a contributing factor.NTSB ATL01LA029Accident · Minor injuriesLimited investigationFinal reportRobert D. Wood Velocity Xlfg · Sebastian, FLThe manufacturer's inadequate design of the winglet/rudder assembly, and inadequate bonding techniques for metal to fiber structures, which resulted in control surface flutter.NTSB MIA01GA070Accident · 2 fatalFinal reportPiper PA-32-300 · Marathon, FLThe pilot-in-command's lack of recent experience in instrument flight resulting in the pilot becoming spatially disoriented, and subsequent in-flight collision with water while descending.NTSB LAX01LA089Accident · Minor injuriesLimited investigationFinal reportArthur Dragonfly · Marana, AZA total loss of engine power for undetermined reasons. Contributing to the accident was the rough/uneven terrain.NTSB CHI01LA079Accident · No injuriesLimited investigationFinal reportCessna 310R · Cahokia, ILThe collapse of the left main landing gear during landing roll for undetermined reasons.NTSB CHI01LA078Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Charlevoix, MIThe pilot failed to maintain directional control of the airplane due to inadequate compensation for the wind conditions. Factors associated with the accident were the gusty crosswind, the icy runway, and the snow bank.NTSB NYC01LA074Accident · No injuriesLimited investigationFinal reportBeech B-19 · Louisa, VAThe pilot's failure to maintain airspeed, which resulted in a hard landing. Factor's in this accident were the loss of electrical power due to an alternator failure and the night light conditions.NTSB LAX01LA083Accident · Minor injuriesLimited investigationFinal reportEurocopter AS-350-B2 · Lihue, HIThe manufacturer's inadequate collective lock design, which resulted in the collective unlocking during a preflight check and subsequent unintentional liftoff and loss of helicopter control. The pilot's loss of control was due in part to the unavailability of…NTSB FTW01LA057Accident · Minor injuriesLimited investigationFinal reportBeech BE-58 · Brinkley, ARthe pilot's poor inflight planning and decision making which resulted in his executing a precautionary landing in a soft field. A contributing factor was the lack of suitable terrain for the precautionary landing.NTSB ATL01LA028Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Concord, NCThe pilots failure to follow the auxiliary fuel tank procedures, which resulted in the fuel starvation and the loss of engine power.NTSB MIA01WA069Accident · 3 fatalForeign investigationYopal, ColombiaNTSB DEN01LA051Accident · No injuriesLimited investigationFinal reportCessna 172 · Grand Junction, COFailure by the pilot to maintain directional control of the aircraft during landing roll. A factor was lack of total pilot experience in aircraft make and model.NTSB DCA01WA018Accident · No injuriesForeign investigationCessna CitationJET (525) · Salcea, RomaniaNTSB CHI01LA106Accident · No injuriesLimited investigationFinal reportCessna 172RG · Sunfield, MIThe pilot's inadequate preflight preparation and the unsuitable terrain for takeoff encountered. Factors included the slushy runway and the snowbank.NTSB CHI01LA076Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Fulton, MOthe pilot not maintaining altitude/clearance from the power line during the circling approach. Factors were the power transmission wire, the plowed field, and that the pilot's lookout was not possible through the built up ice on the windshield.NTSB ATL01LA032Accident · No injuriesLimited investigationFinal reportCessna 208 · Key West, FLThe airplanes' inadvertent collision with a swell during a water landing near a ferry boat that resulted the overload failure of the rear float/strut assembly.NTSB ANC01LA034Accident · No injuriesLimited investigationFinal reportDouglas DC-6B · Crooked Creek, AKThe flight crew's misjudged flare while landing. Factors associated with the accident were flat light conditions, snow-covered terrain, and an uphill runway grade.NTSB NYC01FA073Accident · Serious injuriesField investigationFinal reportCessna 402C · Edgartown, MAThe pilot's failure to maintain a stabilized approach with an adequate vertical and lateral track. Also causal was his failure to maintain obstacle clearance.NTSB FTW01LA055Accident · No injuriesLimited investigationFinal reportSchmidt Questair Venture · Fort Worth, TXThe pilot's failure to maintain directional control during the landing roll. Factors were the crosswind and soft terrain condition.NTSB DEN01LA046Accident · No injuriesLimited investigationFinal reportCessna R172E · Colorado Spring, COthe student pilot's inadequate compensation for the crosswind during landing roll. A contributing factor was the cross wind weather condition.NTSB DCA01WA019Incident · No injuriesForeign investigationBoeing B-777-300 · AustraliaNTSB SEA01LA043Accident · No injuriesLimited investigationFinal reportS.N.I.A.S SE 3130 Alouette II · Driggs, IDThe pilot's failure to maintain aircraft control for undetermined reasons.NTSB MIA01LA068Accident · No injuriesLimited investigationFinal reportCessna 152 · Edgewater, FLThe student pilot's failure to maintain directional control on landing rollout with a crosswind. This resulted in the airplane departing the runway, colliding with a berm/ridge, becoming airborne, and colliding with the terrain in a nose down attitude.NTSB SEA01LA042Accident · No injuriesLimited investigationFinal reportCessna 182R · Renton, WAThe worn condition of the hydraulic pump gears which resulted in a continuous running pump, subsequent pump motor overheat and eventually the tripping of the pump motor circuit breaker. An additional cause was the pilot's failure to verify that the landing…NTSB NYC01FA071Accident · 1 fatalField investigationFinal reportSchempp-Hirth Discus CS · Wurtsboro, NYThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin while on base leg.NTSB MIA01WA067Accident · 7 fatalForeign investigationAero Commander 500 · Tamboril, Dominican RepublicNTSB MIA01LA065Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Tifton, GAThe pilot's failure to properly judge his altitude (too high) during a forced landing to a runway. The pilot made a 270-degree turn in an attempt to lose altitude resulting in a forced landing in a swampy/marshy area short of the runway. Contributing to the…NTSB CHI01LA074Accident · No injuriesLimited investigationFinal reportCessna 150H · Burlington, WIAircraft control not maintained by the pilot during the landing roll. Factors to the accident were the loss of engine power for undetermined reasons, the end of the runway being snow-covered, and the snowbank.NTSB MIA01LA064Accident · No injuriesLimited investigationFinal reportRobinson R22 · Long Beach, MSThe student pilot's failure to relinquish the flight controls while the CFI was demonstrating a takeoff to a hover. This resulted in an in-flight loss of directional control, in-flight collision with terrain, and subsequent roll over.NTSB LAX01LA082Accident · No injuriesLimited investigationFinal reportBeech BE-55 · San Bernardino, CAThe failure of the pilot under instruction to extend the landing gear during the landing approach. A factor was the flight instructor's inadequate supervision.NTSB LAX01LA081Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Camarillo, CAThe failure of the pilot to maintain directional control during takeoff.NTSB FTW01LA056Accident · No injuriesLimited investigationFinal reportNeely B D Kit Fox 4 · Cedar Park, TXthe pilot's excessive braking during the landing roll.NTSB FTW01LA053Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Damon, TXthe pilot's failure to maintain helicopter control during takeoff to a hover, which resulted in a dynamic rollover.NTSB DCA01MA017Accident · 10 fatalClass 1 · MajorFinal reportBeech 200 · Strasburg, COThe pilot’s spatial disorientation resulting from his failure to maintain positive manual control of the airplane with the available flight instrumentation. Contributing to the cause of the accident was the loss of a.c. electrical power during instrument…NTSB NYC01LA069Accident · Minor injuriesLimited investigationFinal reportMooney M-20 · S. Charleston, WVThe pilot's failure to maintain runway alignment during the landing roll.NTSB LAX01WA084Accident · 4 fatalForeign investigationCessna 310R · Newman, AustraliaNTSB FTW01LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Lancaster, TXmaintenance personnel's improper installation of the throttle lever lock nut. A contributory factor was the lack of suitable terrain for the forced landing.NTSB MIA01WA063Accident · 4 fatalForeign investigationPiper PA-34-200T · Augeburg, GermanyNTSB IAD01LA030Accident · No injuriesLimited investigationFinal reportCessna 120 · Trenton, METhe pilot's improper touchdown in the snow after the airplane became prematurely airborne during an attempted takeoff. A factor was the pilot's inadequate training.NTSB DEN01FA045Accident · 2 fatalField investigationFinal reportCessna 182K · Elbert, COthe pilot's continued visual flight rules (VFR) flight into instrument meteorological conditions (IMC), which resulted in an in-flight collision with terrain. Contributing factors to the accident were the low clouds, reduced visibilities due to fog, and the…NTSB DCA01WA016Accident · 24 fatalForeign investigationDouglas DC-3 · Cuidad Bolivar, VenezuelaNTSB CHI01LA075Accident · Serious injuriesLimited investigationFinal reportEnstrom 480 · Dryden, MIThe pilots failure to maintain altitude/clearance from the terrain. The dark night was a factor.NTSB CHI01IA073Incident · No injuriesIncident investigationFinal reportCanadair CL-600-2B19 · Grand Rapids, MIThe uncommanded deployment of the right flight spoiler due to the fatigue fracture of the spoiler lug.NTSB FTW01WA059Accident · No injuriesForeign investigationCessna T310R · Jeddah, Saudi ArabiaNTSB DEN01FA044Accident · 2 fatalField investigationFinal reportAero Vodochody Aero. Works L-39CT · Watkins, COThe pilot's failure to maintain aircraft control, and the subsequent inadvertent stall/mush. Factors were the pilot's diverted attention due to the failure of the rear canopy's acrylic transparency and the loss of communication with his back seat passenger,…NTSB ATL01FA027Accident · 4 fatalField investigationFinal reportBeech F90-42 · Nashville, TNThe pilot's failure to follow loss of engine power emergency procedures by not feathering the propeller following the loss of engine power for undetermined reasons, resulting in a descent and collision with trees and the ground.NTSB ANC01FA033Accident · 2 fatalField investigationFinal reportDouglas DC-3 · Unalaska, AKThe airplane flightcrew's failure to maintain adequate distance/altitude from mountainous terrain during a departure climb to cruise flight, and the captain's impairment from drugs. Factors in the accident were dark night conditions, and the first officer's…NTSB LAX01LA080Accident · Minor injuriesLimited investigationFinal reportCessna 182RG · Douglas, AZThe student's failure to maintain control of the airplane during the go-around and his premature retraction of the landing gear. A factor was the flight instructor's inadequate supervision of the flight.NTSB LAX01LA079Accident · No injuriesLimited investigationFinal reportHughes 369D · Ely, NVThe mechanic's inadvertent activation of the bleed valve, which resulted in a loss of engine oil and loss of engine power while in cruise flight.NTSB ANC01TA032Accident · No injuriesFinal reportCessna 172 · Kipnuk, AKThe pilot's inadequate compensation for a crosswind during the landing roll. Factors in the accident were the presence of a crosswind, an icy runway and snow covered terrain, the pilot's inadequate preflight planning/preparation, and an inaccurate wind…