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 MIA07LA076Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Fort Lauderdale, FLThe inadequate design of the engine mount by the manufacturer, resulting in collapse of the nose landing gear.NTSB CHI07LA121Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Sidney, OHThe total loss of engine power during initial climb due to oil starvation as a result of improper maintenance. The fixed base operator's failure to advise the pilot that the engine had been operated without oil in the engine and soft terrain were factors.NTSB CHI07LA106Accident · Minor injuriesLimited investigationFinal reportBrowns Vans RV-7A · Gardner, ILEngine failure during cruise flight for undetermined reasons. A factor was the rough/uneven terrainNTSB CHI07LA104Accident · 1 fatalLimited investigationFinal reportPiper PA-22-108 · Ava, MOThe failure of the aileron cable eye splice during cruise flight. Contributing to the accident were improper installation and service of the crimped cable sleeve, which rendered the airplane uncontrollable.NTSB LAX07LA130Accident · 3 fatalLimited investigationFinal reportBeech 35-B33 · Sedona, AZThe pilot's inadequate compensation for the high wind conditions and wind shear encounter on final approach, that led to a failure to maintain an adequate airspeed and a stall.NTSB DFW07CA093Accident · No injuriesData collectionFinal reportDwayne Smith RV-6 · Fort Worth, TXThe loss of engine power during cruise flight for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07CA092Accident · Minor injuriesData collectionFinal reportCessna 182E · Marietta, OKThe airplane noseover due to the pilot's failure to obtain current NOTAM information on the closed airport. A contributing factor was the unsuitable terrain.NTSB CHI07CA105Accident · No injuriesData collectionFinal reportPavliga Hatz CB-1 · Buffalo, MNThe loss of engine power due to the carburetor fuel flow valve becoming stuck in the closed position, which resulted in fuel starvation.NTSB CHI07CA101Accident · No injuriesData collectionFinal reportLuscombe 8A · Chippewa Falls, WIThe pilot intentionally leaving the airplane unoccupied during the engine start, which resulted in the unoccupied airplane traversing into a cornfield. A factor was the rough/uneven cornfield.NTSB NYC07LA094Accident · 2 fatalLimited investigationFinal reportRomeo Lancair Legacy RG · Fulton, NYA loss of engine power during the initial climb after takeoff for undetermined reasons.NTSB NYC07CA097Accident · No injuriesData collectionFinal reportCessna A185F · Ashland, METhe pilot's failure to maintain aircraft control while taxiing, which resulted in a nose over. A factor in this accident was the frozen, slush covered lake.NTSB ENG07WA026Incident · No injuriesForeign investigationBoeing B747-400 · Chicago, ILNTSB CHI07FA102Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · Viburnum, MOThe pilot's loss of aircraft control during cruise flight in instrument meteorological conditions. Factors contributing to the accident were turbulence and icing conditions.NTSB CHI07CA103Accident · No injuriesData collectionFinal reportCessna 172S · Naples, FLThe pilot's failure to maintain directional control of the airplane during landing. A contributing factor to the accident was the runway marker sign.NTSB ATL07CA075Accident · Minor injuriesData collectionFinal reportCessna 182B · ST. Mary's, GAThe pilot's decision to operate an airplane with known deficiencies in equipment (inoperative carburetor heat control cable) resulting in a total loss of engine power due to carburetor icing.NTSB SEA07LA101Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Llano, CAThe failure of the other pilot to maintain directional control during landing roll.NTSB SEA07CA117Accident · No injuriesData collectionFinal reportCessna U206G · Glendale, AZThe pilot's failure to properly latch the door prior to takeoff.NTSB MIA07LA075Accident · No injuriesLimited investigationFinal reportCharles C. Gillis Pitts S2S · Zellwood, FLThe pilot's excessive braking during the landing roll.NTSB MIA07LA074Accident · Serious injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Sarasota, FLThe total loss of engine power for undetermined reasons during initial climb after takeoff, resulting in a forced landing, and an in-flight collision with transmission wires and terrain.NTSB LAX07LA126Accident · 1 fatalLimited investigationFinal reportArbc 150A · Mecca, CAThe pilot's decision to fly in forecasted unfavorable wind conditions that exceeded the balloon's capabilities.NTSB LAX07CA128Accident · Minor injuriesData collectionFinal reportBellanca 7GCBC · Porterville, CAThe pilot's failure to maintain directional control.NTSB DFW07CA091Accident · No injuriesData collectionFinal reportCessna 320C · McKinney, TXThe collapsed of the right main landing gear as result of the failure of the over center down lock.NTSB CHI07CA109Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Walker, MNThe pilot's inadvertent failure to lower the landing gear.NTSB LAX07LA127Accident · Serious injuriesLimited investigationFinal reportBoeing 757-200 · Los Angeles, CAThe flight's encounter with a turbulence event that occurred while the flight attendants were unseated. Contributing to the accident was the apparent conflicting information provided by the flight deck to the flight attendants and the flight attendants'…NTSB LAX07CA125Accident · Minor injuriesData collectionFinal reportCessna 172M · Stockton, CAThe loss of engine power due to fuel exhaustion resulting from the pilot's inaccurate fuel consumption calculations and failure to refuel while en route.NTSB DCA07FA037Accident · No injuriesClass 1 · FieldFinal reportBombardier CL-600-2B19 · Traverse City, MIThe pilots' decision to land at Cherry Capital Airport (TVC), Traverse City, Michigan, without performing a landing distance assessment, which was required by company policy because of runway contamination initially reported by TVC ground operations personnel…NTSB ATL07CA074Accident · No injuriesData collectionFinal reportPiper PA-28R-201 · Waynesboro, GACompany maintenance personnel’s improper installation of an unapproved oil quick drain plug which resulted in oil exhaustion and subsequent loss of engine power during cruise flight.NTSB DEN07CA086Accident · No injuriesData collectionFinal reportCessna 170A · Watkins, COA total failure during landing roll of the right brake caused by severely worn shoes, causing the caliper pins to engaged misaligned. A contributing factor was the pilot's inability to maintain directional control.NTSB DEN07CA084Accident · No injuriesData collectionFinal reportCessna 180C · Santa Fe, NMExceeding the airplane's maximum demonstrated crosswind component during the takeoff roll. A contributing factor was the crosswind.NTSB CHI07LA108Accident · No injuriesLimited investigationFinal reportSwearingen SA-226T · Wheeling, ILPartial failure of the left engine propeller governor during the takeoff ground roll. Factors included that directional control was not possible by the pilot which subsequently led to a collision with an airport sign.NTSB CHI07CA100Accident · No injuriesData collectionFinal reportCessna 210N · Charlotte, MIThe pilot's inadequate compensation for the wind conditions, inadequate landing flare, failure to maintain directional control, and encounter with a pilot-induced oscillation (porpoise. A contributing factor was the wind gust.NTSB ATL07LA073Accident · 1 fatalLimited investigationFinal reportCulver, Aurther L. Seawind 3000 · Yanceyville, NCThe pilot's failure to maintain clearance/altitude while operating in instrument meteorological conditions (IMC). Contributing to the accident was the pilot's lack of an instrument rating, his improper decision to operate in IMC, a low cloud ceiling, and…NTSB MIA07LA073Accident · 2 fatalLimited investigationFinal reportPiper PA-46-310P · Bird Cay, BahamasThe pilot's poor in-flight weather evaluation, which resulted in flight into a level 6 thunderstorm.NTSB ATL07CA072Accident · Minor injuriesData collectionFinal reportCessna C-150G · Enterprise, ALThe CFI's attempted takeoff with known deficiencies in the engine which resulted in a loss of engine power, a forced landing on muddy terrain, and a nose over.NTSB SEA07LA097Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-151 · Cibecue, AZThe pilot's failure to maintain proper control of the airplane during an off airport landing. Contributing factors were the pilot's psychological condition, impairment due to overdose of prescription medication, inadequate in-flight planning and mountainous…NTSB LAX07FA123Accident · 2 fatalField investigationFinal reportCessna 172N · Page, AZThe pilot's failure to maintain an adequate terrain clearance altitude, and, his failure to maintain an adequate airspeed while maneuvering to reverse course in a box canyon. Contributing to the accident were the rising terrain and the box canyon.NTSB DEN07LA083Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Topeka, KSThe use of unapproved bolts to mount the crankshaft and gear together, causing fatigue and failure of those mounting bolts, resulting in the subsequent loss of engine power. Factors contributing to the accident were the separation of the crankshaft gear, and…NTSB DEN07LA082Accident · No injuriesLimited investigationFinal reportCirrus SR22 · Luna, NMthe pilot's failure to activate the pitot heat while flying in the clouds and visible moisture, resulting in pitot tube contamination and the subsequent loss of air data for the primary flight display. Contributing to the accident was the icing conditions,…NTSB CHI07WA099Accident · 3 fatalForeign investigationPiper PA-28R-201T · Oban, Scotland, United KingdomNTSB CHI07LA098Accident · 2 fatalLimited investigationFinal reportWakewood Lancair O-200 · Scottsbluff, NEThe pilot's failure to maintain adequate airspeed which resulted in a stall. Contributing to the accident were the low altitude at which the airplane was operating and the gusty wind conditions.NTSB ATL07FA069Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300T · Andrews, NCThe pilot's misjudgment of distance and altitude during a night approach for landing, resulting in an in flight collision with wires and the ground.NTSB SEA07LA095Accident · No injuriesLimited investigationFinal reportDiemert/Rotorway Exec 162 F · Roseburg, ORa total loss of engine power due to the failure of the primary and secondary electronic control units (ECU's) within the engine's Fully Automated Digital Electronic Control.NTSB LAX07LA122Accident · 1 fatalLimited investigationFinal reportScottish Bulldog 120 · So Lake Tahoe, CAThe pilot's failure to maintain clearance from objects and the mountainous terrain.NTSB DEN07CA085Accident · No injuriesData collectionFinal reportBeech F-35 · Wheatland, WYThe pilot's inadequate soft field takeoff procedures and the low airspeed resulting in the airplane settling back to the ground.NTSB CHI07FA107Accident · No injuriesField investigationFinal reportCanadair CL-600-2B19 · Lake Michigan, MIIn-flight separation of the left engine thrust reverser translating cowling due to intermittent binding and jamming of the reverser on the accident flight and on previous flights. Contributing factors were the inadequate maintenance action by the operator due…NTSB ATL07CA071Accident · No injuriesData collectionFinal reportCessna C-150H · Dyersburg, TNThe student's pilot's misjudged distance/altitude that led to an undershoot and a failure to attain the proper touchdown point.NTSB SEA07LA094Accident · No injuriesLimited investigationFinal reportCessna 172 · Chiriaco Summit, CAEngine fire during start-up for undetermined reasons.NTSB SEA07CA099Accident · No injuriesData collectionFinal reportBarnett MA-5 Charger · San Martin, CACarburetor icing conditions which resulted in a loss of engine power during the base turn to final approach. The pilot's inadequate preflight planning/preparation for the flight was a factor.NTSB SEA07CA096Accident · No injuriesData collectionFinal reportCessna 172L · North Las Vegas, NVThe loss of engine power for undetermined reasons. A contributing factor was the sign.NTSB NYC07IA092Incident · No injuriesIncident investigationFinal reportCirrus Design SR20 · Leesburg, VAThe airplane manufacturer's inadequate rudder-aileron interconnect rigging information. Contributing to the incident was the design of the rudder-aileron interconnect system.