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 CEN09FA087Accident · 1 fatalField investigationFinal reportBeech C90 · Rocksprings, TXThe pilot's failure to properly configure the pressurization controls, resulting in his impairment and subsequent incapacitation due to hypoxia.NTSB ERA09FA087Accident · 2 fatalField investigationFinal reportErcoupe 415-D · Sebring, FLThe pilot's exceedance of the design stress limitations of the airplane.NTSB ERA09CA091Accident · No injuriesData collectionFinal reportKimball Enterprises Pitts Model-12 · Weirdales, FLThe pilot's inadequate compensation for the wind conditions. Contributing to the accident was the crosswind.NTSB ERA09CA089Accident · Serious injuriesData collectionFinal reportMooney M20G · Sebastian, FLThe loss of engine power for undetermined reasons.NTSB ERA09LA096Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · New Bern, NCA loss of engine power for undetermined reasons.NTSB DCA09WA019Accident · No injuriesForeign investigationBoeing · Stuttgart, Germany.NTSB CEN09IA096Incident · No injuriesIncident investigationFinal reportCessna 182 · Fort Worth, TXCollision with a hidden obstruction while taxiing through a grass field following a forced landing. Contributing to the accident was a loss of engine power due to the pilot's failure to turn on the carburetor heat.NTSB WPR09WA249Incident · No injuriesForeign investigationEmbraer EMB145 · Kemi, FinlandOn December 11, 2008, at 2253 universal coordinated time, an Embraer EMB145, registration OH-EBE, sustained minor damage to the tailcone after the Auxillary Power Unit (APU) caught fire during taxi after landing at Kemi-Tornio Airport, Kemi, Finland. The…NTSB ERA09IA115Incident · No injuriesIncident investigationFinal reportCessna 402C · Fort Lauderdale, FLThe airplane manufacturer's inadequate inspection procedure resulting in undetected fatigue cracking of the main landing gear barrel of the upper barrel and trunnion assembly.NTSB DCA09IA018Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD88 · Greer, SCThe overheating and arcing of the DC Ground Service Relay and Block Diodes component for undetermined reasons.NTSB CEN09FA086Accident · 5 fatalField investigationFinal reportBell 206L-4 · Sabine Pass, TXThe pilot’s failure to maintain clearance from the water. Contributing to the accident was the inadvertent encounter with instrument meteorological conditions.NTSB WPR09LA056Accident · 1 fatalLimited investigationFinal reportCessna 172 · Lompoc, CAThe pilot's failure to maintain clearance from the power line. Contributing to the accident was the pilot's lack of recent experience.NTSB ERA09FA083Accident · Minor injuriesField investigationFinal reportMitsubishi MU-2B-60 · Millington, TNThe pilot’s improper configuration of the airplane following an engine shutdown, which resulted in a low-altitude, unstabilized approach. Contributing to the accident was a loss of engine power for undetermined reasons.NTSB ERA09CA095Accident · No injuriesData collectionFinal reportBeech C23 · Panacea, FLA loss of engine power due to a failure of the mixture control cable housing attachment.NTSB CEN09WA082Accident · 2 fatalForeign investigationLearjet Lear 23 · Tlaxcala, MexicoOn December 7, 2008 at approximately 1815 central standard time (CST) a twin-engine turbo fan, Learjet 23, Mexican Registration XC-LGD, was destroyed when it impacted a lake while on final approach to an unlit day visual flight rules airport near Tlaxcala,…NTSB ERA09WA085Accident · 1 fatalForeign investigationMaule M7 · Cobra River, Manaus, BrazilOn December 7, 2008, about 1115 universal coordinated time, a Maule M-7-235, Brazilian registration PT-ONN, was substantially damaged when it impacted trees while departing from the Taruma River, Manaus, Brazil. The floatplane subsequently came to rest in the…NTSB ERA09LA081Accident · No injuriesLimited investigationFinal reportMerrell Stephen F1 Rocket · Sebastian, FLA loss of engine power due to fuel starvation as a result of the pilot's incorrect positioning of the fuel selector valve.NTSB ERA09CA097Accident · Serious injuriesData collectionFinal reportMiller Long EZ/XP · Wauchula, FLA total loss of engine power for undetermined reasons.NTSB ERA09CA082Accident · Minor injuriesData collectionFinal reportCessna 208 · Homestead, FLThe inadvertent deployment of the reserve parachute, resulting in the skydiver being prematurely pulled from the airplane and striking the horizontal stabilizer.NTSB ERA09FA080Accident · 4 fatalField investigationFinal reportPiper PA-44-180 · Ft. Lauderdale, FLThe failure of both pilots to see and avoid the other aircraft.NTSB ERA09CA086Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Linden, NJThe unknown pilot's failure to maintain adequate clearance from the taxiway sign.NTSB CEN09FA083Accident · 1 fatalField investigationFinal reportCessna 206H · Kalkaska, MIThe pilot's failure to maintain clearance from trees and terrain during the instrument-flight-rules flight. Contributing to the accident was the pilot's failure to comply with instrument flight procedures and his lack of recent instrument flight experience.NTSB CEN09CA084Accident · No injuriesData collectionFinal reportRockwell International 114 · Meacham Int'l Airport, TXThe pilot's failure to maintain pitch control during landing.NTSB WPR09CA054Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Goodyear, AZThe failure of the student pilot to maintain directional control during takeoff.NTSB ERA09LA079Accident · No injuriesLimited investigationFinal reportFlight Design Ctsw · Punta Gorda, FLThe pilot's failure to maintain control of the airplane during a rejected takeoff. Contributing to the accident was a gust of wind.NTSB CEN09CA156Accident · No injuriesData collectionFinal reportRockwell International 500-S · Grand Forks, NDThe pilot's failure to extend the landing gear prior to touchdown.NTSB CEN09CA092Accident · No injuriesData collectionFinal reportCessna 150 · Auxvasse, MOthe pilot's improper engine recovery procedures after a power-off stall which resulted in a loss of engine power. Contributing factors were the pilot's improper off-field landing procedures, and the lack of suitable terrain for the forced landing.NTSB CEN09CA081Accident · No injuriesData collectionFinal reportCessna A185F · Alton, ILThe pilot's failure to compensate for the crosswind during landing, resulting in loss of control of the aircraft and the subsequent nose-over of the airplane. Contributing to the accident was the crosswind.NTSB ERA09WA084Accident · 2 fatalForeign investigationAero Commander 500 · Cordoba, Colombia, ColombiaOn December 03, 2008 about 1835 eastern standard time, an Aero Commander 500, of Colombian registration, HK1697, registered to an individual and operated by Taxi Aero Caribeno LTDA, crashed in an open field, near Cordoba, Colombia. Visual meteorological…NTSB ERA09FA078Accident · 3 fatalField investigationFinal reportRockwell International 690B · Rio Grande, PRThe pilot's continued visual flight into instrument meteorological conditions, which resulted in an in-flight collision with terrain.NTSB CEN09LA093Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas DC-9-50 · Madison, WIThe collision between the tug and the airplane during towing as a result of sliding on the snow covered runway.NTSB WPR09CA055Accident · No injuriesData collectionFinal reportCessna 172RG · Truckee, CAThe pilot misjudged the landing flare resulting in a hard landing.NTSB WPR09LA050Accident · 1 fatalLimited investigationFinal reportBeech A36 · Coalinga, CAThe loss of engine power while in climb to cruise flight for undetermined reasons.NTSB ERA09CA217Accident · No injuriesData collectionFinal reportPiper PA-32R-300 · Middletown, DEThe pilot's failure to maintain aircraft control while landing in gusty conditions.NTSB ERA09FA074Accident · 2 fatalField investigationFinal reportBeech 35-B33 · Homosassa Spgs., FLThe pilot’s continued flight into known adverse weather conditions.NTSB CEN09CA077Accident · No injuriesData collectionFinal reportPiper PA-15 · Pleasanton, TXThe pilot's failure to adequately secure the airplane while hand-starting the engine.NTSB WPR09LA052Accident · Serious injuriesLimited investigationFinal reportAdkins Ridge Runner II · Mulino, ORThe pilot's failure to attain an adequate airspeed that resulted in a stall/mush during the initial climb. Contributing to the accident were the pilot's lack of experience in this make and model airplane and the improper adjustment of the propeller pitch.NTSB WPR09CA053Accident · No injuriesData collectionFinal reportCessna 172 · Sedona, AZThe pilot's improper flare and inadequate recovery from a bounced landing.NTSB WPR09CA051Accident · No injuriesData collectionFinal reportBeech B60 · Rock River, WYThe pilot's failure to maintain clearance from a power line due to the lack of forward visibility because of an ice-covered windshield. Contributing to the accident was the flight's encounter with icing weather conditions.NTSB ERA09WA076Accident · 4 fatalForeign investigationBeech 58 · Anapolis, BrazilOn November 28, 2008, at 1835 Atlantic standard time, a Beech 58, N400SA, was destroyed during a local personal flight when it impacted the ground after a low pass at Anapolis JK Airport (SWNS), Anapolis, Goias, Brazil. The pilot and 3 of the 5 passengers…NTSB ERA09CA073Accident · Minor injuriesData collectionFinal reportExtra Flugzeugbau EA 300/L · Tampa, FLThe pilot's inadequate visual lookout, which resulted in a collision with an object.NTSB CEN09CA089Accident · No injuriesData collectionFinal reportCessna 182 · Gillespie, ILThe pilot's decision to take off with a known obstacle on the runway.NTSB WPR09LA049Accident · Serious injuriesLimited investigationFinal reportRaytheon G36 · Porterville, CAA loss of engine power for undetermined reasons.NTSB ERA09CA077Accident · No injuriesData collectionFinal reportCessna 172I · Frederick, MDThe student pilot's delayed decision to abort the landing.NTSB DCA09RA013Accident · 7 fatalForeign investigationAirbus A320 · Perpignan, FranceOn November 27, 2008 at 16:46 local time (15:46 UTC), an Airbus A320, equipped with International Aero Engines (IAE) V2500 engines, German registration D-AXLA, serial number 2500, impacted the Mediterranean sea during approach to runway 33 at Perpignan…NTSB WPR09LA046Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Monterey, CAThe pilot's inadequate fuel system management and inflight planning that led to a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's failure to use the landing checklist.NTSB ERA09LA072Accident · Serious injuriesLimited investigationFinal reportLeroy Lakey Corben ACE · Cherryville, NCA throttle control malfunction during initial climb, as reported by the pilot.NTSB DCA09IA014Incident · No injuriesIncident investigationFinal reportBoeing 777 · Bozeman, MTAn accumulation of ice in the fuel system, which formed from the water normally present in jet fuel during commonly encountered flight conditions, which accreted and released, restricting the fuel flow at the right engine fuel-oil heat exchanger inlet face.…NTSB CEN09CA078Accident · No injuriesData collectionFinal reportCessna 172S · Waukesha, WIThe pilot's failure to maintain aircraft control during takeoff and his failure to ensure that the elevator trim was properly set before takeoff. Contributing to the accident was the pilot's lack of autopilot system knowledge.NTSB WPR09LA048Accident · No injuriesLimited investigationFinal reportHughes 369HS · Fillmore, UTThe loss of engine power due to fuel starvation as a result of a loose fuel filter upper drain cap, which was not properly secured by maintenance personnel.