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 CEN09LA124Accident · Minor injuriesLimited investigationFinal reportLavigna Lancair IV P · Iola, KSThe total loss of engine power for undetermined reasons.NTSB WPR09LA075Accident · No injuriesLimited investigationFinal reportCzech Aircraft Works Sport Cruiser · Casa Grande, AZThe pilot's failure to ensure that the canopy was latched prior to takeoff. Contributing to the accident was the inadequate guidance in the Pilot Operating Handbook regarding canopy procedures.NTSB WPR09LA074Accident · No injuriesLimited investigationFinal reportRowland GS-2 Sport · Ramona, CAA total loss of engine power for undetermined reasons.NTSB ERA09LA131Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Pensacola, FLThe pilot’s failure to maintain airspeed following a total loss of engine power during a low-level approach, which resulted in an aerodynamic stall. Contributing to the accident was fuel exhaustion due to the pilot’s inadequate preflight planning.NTSB ENG09RA003Incident · No injuriesForeign investigationBoeing 777 · Ho Chi Minh City, VietnamOn January 1, 2009, a Vietnam Airlines Boeing 777-200, registration VN-A143, flight number VN224, departed the Tan Son Nhat Airport, SGN (Ho Chi Minh City) and while climbing through 8,000 feet, a loud metallic noise was heard followed by a L ENGINE FAIL…NTSB CEN09LA122Accident · No injuriesLimited investigationFinal reportBeech A36TC · Three Rivers, MIThe pilot's decision to continue the flight into an area with conditions that were conducive to icing and the loss of engine power due to induction icing.NTSB WPR09FA072Accident · No injuriesField investigationFinal reportEurocopter AS 350 BA · Honolulu, HIThe partial loss of engine power during landing for an undetermined reason.NTSB WPR09CA073Accident · No injuriesData collectionFinal reportCessna 152 · Long Beach, CAThe student pilot's failuire to maintain directional control during takeoff.NTSB CEN09LA132Accident · No injuriesLimited investigationFinal reportGrumman American Avn. AA-5B · Milford, INA loss of engine thrust due to the separation of a section of one of the propeller blades as a result of fatigue failure of the propeller because of corrosion. Contributing to the accident was the failure of the mechanic to detect and address the propeller…NTSB ERA09LA130Accident · No injuriesLimited investigationFinal reportCessna 550 · Wilmington, NCA loss of engine power due to the crew's inadequate in-flight fuel monitoring.NTSB ERA09LA124Accident · 1 fatalLimited investigationFinal reportPiper PA-28-160 · Indiana, PAThe pilot's decision to attempt VFR flight in IMC conditions, resulting in a collision with trees during a go-around.NTSB CEN09MA117Accident · 8 fatalMajor investigationFinal reportSikorsky S-76C · Morgan City, LA(1) the sudden loss of power to both engines that resulted from impact with a bird (red-tailed hawk), which fractured the windshield and interfered with engine fuel controls, and (2) the subsequent disorientation of the flight crewmembers, which left them…NTSB WPR09LA071Accident · Minor injuriesLimited investigationFinal reportPZL PZL-104 35A · Oakland, CAA loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate preflight planning.NTSB ERA09LA123Accident · 2 fatalLimited investigationFinal reportPiper PA-28-151 · Powder Springs, TNThe non-instrument rated pilot's decision to continue under visual flight rules into an area of instrument meteorological conditions, which resulted in an in-flight collision with terrain.NTSB CEN09LA116Accident · Minor injuriesLimited investigationFinal reportLearjet 45XR · Telluride, COThe failure of both pilots to positively identify the runway prior to landing.NTSB CEN09FA115Accident · 2 fatalField investigationFinal reportNanchang China CJ-6 · Justin, TXThe pilot's failure to maintain adequate airspeed while maneuvering on approach, which resulted in an accelerated stall and subsequent loss of control.NTSB CEN09CA120Accident · No injuriesData collectionFinal reportBeech 58 · Brainerd, MNThe pilot's improper flare which resulted in a hard landing. Contributing to the accident was the unforcasted freezing rain that obscured the windscreen and hindered the pilot's ability to judge the height of the airplane above the runway.NTSB ERA09LA128Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-602 · Philadelphia, MSThe pilot's improper preflight weather planning and his continued VFR flight into IMC conditions resulting in an in-flight collision with trees.NTSB ENG09IA002Incident · No injuriesIncident investigationFinal reportBoeing 777 · Atlanta, GAThe fan blade fractured due to a fatigue crack that was the result of the combination of the breakdown of the fan blade lubrication system and residual fatigue life usage following the last overhaul of the fan blade. Contributing to the fracture was the…NTSB CEN09WA129Accident · 1 fatalForeign investigationEurocopter Deutsch EC 135 T2 · Molesmes, FranceUnder the jurisdiction and control of the French government.NTSB CEN09FA111Accident · 2 fatalField investigationFinal reportLantzair Flyers Lancair 360 · Joliet, ILThe pilot’s failure to maintain adequate flying speed during the night takeoff for undetermined reasons, which resulted in an inadvertent aerodynamic stall and subsequent loss of controlNTSB ERA09CA119Accident · No injuriesData collectionFinal reportCessna 172SP · Lancaster, NYThe student pilot's failure to maintain directional control during takeoff. Contributing to the accident was the student pilot's lack of solo flight experience and the snow bank located off the left side of the runway.NTSB ERA09FA116Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Pittstown, NJThe pilot's failure to maintain an adequate clearance from trees during the night landing approach and the flight instructor's inadequate remedial action.NTSB ERA09CA127Accident · No injuriesData collectionFinal reportCessna 180K · Port Orange, FLThe pilot's inadequate compensation for the wind conditions during landing. Contributing to the accident were the gusting wind conditions and the pilot's lack of experience in the make and model airplane.NTSB ERA09CA120Accident · No injuriesData collectionFinal reportSchweizer 269C · Panama City, FLThe pilot's encounter with a loss of tail rotor effectiveness during an out-of-ground-effect hover.NTSB ERA09CA118Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-5 · Brunswick, GAThe pilot's failure to maintain control of the airplane during the landing flare. Contributing to the accident were the gusting winds.NTSB DCA09WA024Incident · No injuriesForeign investigationBoeing 737 · Luton Airport, United KingdomOn December 31, 2008, at 1700 UTC, an EasyJet Boeing 737-73V, registered in the United Kingdom as G-EZKB, experienced a rapid pitch up upon takeoff from Luton Airport, United Kingdom. The aircraft had been deiced, but was exposed to icing conditions later…NTSB DCA09FA025Accident · No injuriesField investigationFinal reportEmbraer EMB145 · New York, NYThe tug driver's failure to comply with ramp safety procedures.NTSB CEN09CA123Accident · No injuriesData collectionFinal reportCessna T210M · Fort Collins, COA total loss of engine power due to fuel starvation as a result of the pilot's failure to select the fullest tank before landing.NTSB CEN09CA121Accident · No injuriesData collectionFinal reportCessna 150M · Greene, IAA loss of engine power due to undetermined reasons. Contributing to the accident was the rough, snow-covered terrain.NTSB ANC09LA017Accident · No injuriesLimited investigationFinal reportCessna 207A · Hoonah, AKThe pilot's failure to ensure that the aft cargo door was properly latched and locked prior to departure, which resulted in an in-flight opening of the aft cargo door and subsequent damage to the airplane.NTSB WPR09CA093Accident · No injuriesData collectionFinal reportStemme S-10 · San Jose, CAThe pilot's failure to maintain clearance from an obstacle during taxi.NTSB ERA09WA206Accident · 3 fatalForeign investigationBeech V35 · Valenca, BrazilOn December 30, 2008, about 1240 UTC, or 1040 local, a Beech V35B, Brazilian registration PT-JKU, registered to and operated by Unibase Engenharia e Pavimentacao Ltda, collided with mountainous terrain near Valenca, RJ, Brazil. Instrument meteorological…NTSB ERA09CA117Accident · No injuriesData collectionFinal reportBeech G35 · Chattanooga, TNThe pilot's failure to see and avoid the marked helicopter dolly. Contributing to the accident were the dark night conditions.NTSB CEN09LA113Accident · No injuriesLimited investigationFinal reportCotton Galen M Helicycle · Houston, TXThe loss of engine power during a hover landing which resulted in a hard landing.NTSB ERA09LA114Accident · No injuriesLimited investigationFinal reportJohnson Barron T Lancair 360 · Owensboro, KYThe loss of engine power due to fuel starvation. Contributing to the accident was the failure of the fuel selector valve cotter pin and the inoperative main (center) fuel tank gauge.NTSB ERA09CA112Accident · No injuriesData collectionFinal reportMichael Muratore Vans · Bayport, NYThe pilot's failure to stop the airplane within the available runway after touchdown. Contributing to the accident were the failure of the flap system as reported by the pilot and the damp grass.NTSB DCA09WA032Accident · No injuriesForeign investigationSikorsky S76 · Rio De Janiero, BrazilOn December 29, 2008, a Sikosky S-76 helicopter, Brazilian registration PR-IME, was substantially damaged by fire following a forced landing at Rio De Janiero, Brazil. The flight crew noted an AC generator light shortly after departure, and began a return to…NTSB CEN09CA208Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Valparaiso, INThe pilot's improper flare during landing, resulting in a bounced landing.NTSB WPR09LA069Accident · 1 fatalLimited investigationFinal reportHughes 369 · Honiara, Solomon IslandsThe pilot's failure to remove the tail rotor pedal lock before attempting flight, resulting in a loss of control.NTSB WPR09IA070Incident · No injuriesIncident investigationFinal reportMD Helicopter MD 900 · Kamuela, HIThe separation of the endplate bolts for undetermined reasons, resulting in an in-flight separation of the right endplate. Contributing to the accident was the manufacturer's failure to provide sufficient guidance for endplate bolt installation.NTSB WPR09FA068Accident · No injuriesField investigationFinal reportBoeing 757-351 · Seattle, WAThe failure of the tug operator and wing walker of the other airplane to maintain clearance with this aircraft during the pushback process in dark night. Also causal was the ramp controller's misinterpretation of the other airplane's gate location and her…NTSB ERA09CA129Accident · No injuriesData collectionFinal reportBuckeye Dream Machine · Grant, FLThe pilot's failure to maintain clearance from the wire.NTSB CEN09LA107Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Palenstine, TXThe failure of the pilot to ensure security of the cockpit switches before rotating the propeller.NTSB CEN09LA105Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Santo Domingo Pueblo, NMA loss of engine power due a loss of oil pressure resulting in heat distress and mechanical failure of the engine. The reason for the loss of oil pressure was not determined.NTSB ANC09CA016Accident · No injuriesData collectionFinal reportCessna 172S · Girdwood, AKThe flight instructor's lack of action to correct a high and fast landing approach which resulted in a long landing, and subsequent collision with a snow berm at the end of the runway. Contributing to the accident was the student pilot's improper approach.NTSB WPR09CA067Accident · No injuriesData collectionFinal reportCessna 208B · Rock Springs, WYThe pilot's failure to maintain control of the airplane while taxiing. Contributing to the accident were the gusty winds.NTSB ERA09WA214Accident · No injuriesForeign investigationPiper PA31-350 · Lorenzo, BrazilOn March 23, 2009, at 1700 Atlantic standard time, a Piper PA31-350 Chieftain, PT-EHG, sustained minor damage from a landing-gear brake fire after landing at Lorenzo Airport (SNCL), Cairu, Brazil. The pilot and seven passengers were not injured. Visual…NTSB ERA09LA109Accident · No injuriesLimited investigationFinal reportMichel Paul John Murphy Rebel · Live Oak, FLA partial loss of engine power for undetermined reasons.NTSB ERA09LA108Accident · Serious injuriesLimited investigationFinal reportBeech E18S · Fort Myers, FLThe failure of the right propeller to go to the feathered position for undetermined reasons following a total loss of right engine power during initial climb due to fuel starvation as a result of the pilot's improper fuel planning.