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 WPR09CA231Accident · Serious injuriesData collectionFinal reportFuhrmann-Super Emeraude Stretched · Peach Springs, AZThe airplane's encounter with turbulence after takeoff, which resulted in an uncontrolled descent and collision with terrain.NTSB DCA09WA050Accident · No injuriesForeign investigationFrankfurt, GermanyOn May 8, 2009, at 1959 UTC a Boeing 747-400, Korean registration HL7419, operated by Asiana Airlines lost an inboard trailing edge flap during approach to Frankfurt/Main Airport, Germany. There were no injuries on the scheduled flight from Seoul, South…NTSB DCA09WA049Accident · No injuriesForeign investigationMcdonnell Douglas MD90 · Riyadh, Saudi ArabiaOn May 8, 2009, at 1558 local time, a Boeing McDonnell Douglas MD90, Saudi Arabian registration HZ-APW; S/N 53513, operated by Saudi Arabian Airlines was damaged when exiting a high-speed taxiway after landing on runway 15R at Riyadh Airport. The laft main…NTSB CEN09LA284Accident · Minor injuriesLimited investigationFinal reportCessna 421B · Alpine, TXThe loss of engine power due to disengagement of the magneto idler gear support pin.NTSB CEN09CA295Accident · Minor injuriesData collectionFinal reportAir Tractor AT502 · Lisse, TXA total loss of engine power for undetermined reasons.NTSB CEN09CA253Accident · No injuriesData collectionFinal reportCessna 172N · Roanoke, TXThe partial loss of engine power due to a failure of the throttle control rod-end to carburetor arm hardware. A contributing factor was the pilot's decision to fly the airplane without a current annual inspection.NTSB WPR09LA230Accident · Minor injuriesLimited investigationFinal reportCessna T210G · Santa Rosa, CAA total loss of engine power on final approach for undetermined reasons.NTSB ERA09LA284Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Winter Haven, FLA loss of engine power for undetermined reasons.NTSB CEN09WA286Accident · 3 fatalForeign investigationCessna 340 · Veracruz, MexicoOn May 5, 2009 at about 0900 central daylight time a Cessna 340, Mexican Registration XB-CUC crashed while returning to land after takeoff at General Heriberto Jara Corona International Airport, Veracruz, Veracruz, Mexico. The pilot requested to return to the…NTSB CEN09CA283Accident · No injuriesData collectionFinal reportGulfstream-Schweizer A/C Gulfstream · Iowa, LAA partial loss of engine power due to the Number 8 cylinder head cracking and separating from the barrel.NTSB WPR09LA228Accident · Serious injuriesLimited investigationFinal reportAyres S2R-T34 · Marysville, CAThe failure of both pilots to see and avoid the other airplane while making their final approach for landing.NTSB ERA09FA283Accident · 2 fatalField investigationFinal reportBeech K35 · Lantana, FLA total loss of engine power due to disengagement of the idler gear support pin as a result of improper maintenance.NTSB DCA09FA048Accident · Serious injuriesField investigationFinal reportBoeing DC-10 · Baltimore, MDthe captain’s inappropriate control inputs following a firm landing, resulting in two hard nose-gear impacts before executing a go-around. Contributing to the inappropriate control inputs was the captain’s fatigue and physical discomfort; and a possible lack…NTSB CEN09CA282Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Seminole, OKThe pilot's failure to maintain directional control during takeoff.NTSB ANC09LA038Accident · Minor injuriesLimited investigationFinal reportCessna TU206 · Bethel, AKThe pilot’s failure to remove visible frost from the wings during the preflight inspection, and his failure to maintain adequate airspeed to avoid a stall. Contributing to the accident were conditions conducive to structural icing/frost.NTSB CEN09LA281Accident · No injuriesLimited investigationFinal reportCessna 551 · Stillwater, OKThe pilot's loss of control for undetermined reasons.NTSB ANC09CA037Accident · No injuriesData collectionFinal reportCessna 140 · Haines, AKThe pilot's decision to practice takeoff and landings on unsuitable terrain, which resulted in a nose-over on takeoff.NTSB WPR09LA227Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Colfax, WAA total loss of engine power due to excessive wear in several carburetor components that led to a malfunction of the carburetor.NTSB ERA09LA281Accident · Serious injuriesLimited investigationFinal reportPolaris Motors 582 FIB · Lexington, SCThe non-certificated pilot's failure to maintain airspeed during initial climb, which resulted in an aerodynamic stall. Contributing to the accident was the non-certificated pilot’s lack of experience in the make and model airplane.NTSB DCA09FA047Accident · Minor injuriesField investigationFinal reportAirbus A320 · Denver, COThe first officer’s excessive pitch-up of the airplane while landing with a tailwind, which resulted in a tailstrike following a bounced landing. Contributing to the bounced landing were a high descent rate and excessive thrust resulting from the first…NTSB CEN09LA278Accident · Serious injuriesLimited investigationFinal reportGlasflugel H201B · Meadow Lake Airport, COA programming anomaly within the winch's computer aided launch control system, which incorrectly limited the maximum winch speed during launch of the glider.NTSB CEN09LA274Accident · Serious injuriesLimited investigationFinal reportBeech 35-C33 · Addison, TXA loss of engine power in flight due to fuel starvation as a result of the pilots' inadequate fuel management.NTSB CEN09CA275Accident · No injuriesData collectionFinal reportBell 407 · High Island 138The pilot's failure to maintain clearance from the windsock during the approach.NTSB WPR09CA224Accident · No injuriesData collectionFinal reportRobinson R44 · Cottonwood, AZThe pilot's inadequate visual lookout and failure to maintain clearance from wires.NTSB CEN09LA277Accident · 2 fatalLimited investigationFinal reportChampion 7GCBC · Surrey, NDThe pilot’s failure to maintain control of the airplane during an abrupt pull-up maneuver, which resulted in an aerodynammic stall at low altitude.NTSB CEN09CA280Accident · No injuriesData collectionFinal reportCessna 152 · Opelousas, LAA total loss of engine power due to fuel exhaustion as a result of the pilot's failure to refuel the airplane prior to flight.NTSB CEN09CA279Accident · Minor injuriesData collectionFinal reportAmerican AA-1 · Cumberland, WIThe pilot's failure to maintain control of the aircraft during takeoff in crosswind conditions.NTSB DCA10WA008Incident · No injuriesForeign investigationBoeing 737 · Antalya, TürkiyeOn May 2, 2009, a Boeing 737, registration FG-FUF, operated by Europe Airpost, encountered turbulence and possibly entered an unusual attitude north of Antalya, Turkey. The BEA France is conducting an investigation.NTSB CEN09LA276Accident · Serious injuriesLimited investigationFinal reportHawkins August E Aventura II · Griffith, INThe pilot's failure to maintain control of the airplane due to an inadvertent stall. Contributing to the accident was the failure of the airspeed indicator due to separation of the pitot-static line at the left wing root.NTSB WPR09LA226Accident · No injuriesLimited investigationFinal reportMD Helicopter 369FF · Santa Clarita, CAThe pilot's failure to maintain clearance from the water while maneuvering at low altitude as a result of the helicopter's grappling hook temporarily becoming ensnared with an underwater obstruction.NTSB WPR09LA223Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Puyallup, WAA loss of engine power due to fuel starvation as a result of the pilot’s failure to verify the fuel levels in the tanks, and, his failure to select the proper fuel tank.NTSB WPR09CA225Accident · No injuriesData collectionFinal reportRans S-7 · Atomic City, IDA loss of engine power due to fuel starvation as a result of the pilot's inadequate fuel management.NTSB ENG09WA006Incident · No injuriesForeign investigationBoeing 757-236 · Guayaquil, EcuadorOn May 1, 2009, 1315 local time, a AEROGAL Boeing 757, powered by Rolls-Royce RB211-535E4 engines experienced a compressor stall after takeoff from the Simon Bolivar International, Guayaquil Ecuador. While climbing through 700 feet, the pilot heard a noise…NTSB WPR09CA220Accident · No injuriesData collectionFinal reportBell OH-58A · Arvin, CAThe pilot’s failure to maintain clearance from wires during aerial application maneuvers.NTSB ERA09CA280Accident · No injuriesData collectionFinal reportCessna 172 · Greenville, METhe pilot’s premature rotation during takeoff.NTSB ERA09CA277Accident · No injuriesData collectionFinal reportPiper PA-30 · Great Barrington, MAThe pilot's improper decision to land with a tailwind.NTSB CEN09CA273Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · New Braunfels, TXThe pilot's failure to maintain adequate main rotor rpm during a practice autorotation. Contributing to the accident was the instructor pilot's delayed remedial action.NTSB ERA09CA275Accident · No injuriesData collectionFinal reportPiper PA-12 · Georgetown, SCThe pilot's failure to maintain directional control during landing roll. Contributing to the accident was the pilot’s lack of experience in the make and model airplane.NTSB DCA09WA060Accident · 7 fatalForeign investigationBoeing 737 · Kwilu, Bandundu, Congo - KinshasaOn April 29, 2009, about 0800 UTC, TL-ADM, a Boeing 737-200, operated by Bako Air of the Central African Republic, a ferry flight, crashed at the locality of Massamba, District of Kwilu, province of Bandundu, Democratic Republic of Congo. All seven occupants…NTSB CEN09CA272Accident · Minor injuriesData collectionFinal reportCessna A185F · Patterson, LAThe pilot's failure to maintain adequate airspeed in a turn while attempting to return to land, which resulted in an aerodynamic stall. Contributing to the accident was the reported loss of engine power for undetermined reasons.NTSB CEN09CA271Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Harlingen, TXThe pilot's decision to leave the helicopter unattended with the engine running in gusty wind conditions.NTSB ERA09WA279Accident · 2 fatalForeign investigationCirrus Design SR22 · Mt. Ainos, GreeceNone.NTSB CEN09FA267Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Mayfield Village, OHThe pilot’s failure to maintain control of the airplane while operating in instrument meteorological conditions due to spatial disorientation. Contributing to the accident was the pilot’s inattention to basic aircraft control while attempting to program the…NTSB ANC09LA036Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Chugiak, AKThe flight instructor's inadequate supervision of the pilot during a simulated loss of engine power, and the pilot's failure to use carburetor heat while operating at a reduced engine power while in carburetor icing conditions.NTSB ERA09LA272Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Chesterfield, SCThe partial loss of engine power due to a broken exhaust valve. Contributing to the accident was the operator's exceedance of the engine manufacturer's recommended time before overhaul.NTSB ERA09IA267Incident · No injuriesIncident investigationFinal reportCessna 402C · Nantucket, MAInstallation of an improper bearing in the landing gear actuator.NTSB ERA09FA273Accident · 1 fatalField investigationFinal reportExplorer Aeronautique Ecoflyer · Lebanon, NYThe in-flight separation of the left wing due to failure of one of the inboard attachments to the fuselage.NTSB ERA09CA274Accident · No injuriesData collectionFinal reportCessna 150K · Waycross, GAThe student pilot's failure to maintain aircraft control during approach in gusty conditions. Contributing to the accident was the student pilot's misunderstanding of the airspeed indicator.NTSB DCA09WA046Accident · Minor injuriesForeign investigationBoeing 737 · Guadalajara, MexicoOn April 27, 2009, at approximately 1638 local time, a Boeing 737-2K9, serial number 22505/815, Mexican registration XA-MAF, operated by Magnicharters as flight 585 landed with main gear retracted on runway 28 at the Guadalajara-Don Miguel Hidalgo y Costilla…NTSB WPR09LA218Accident · No injuriesLimited investigationFinal reportWeinberg RV-6 · Sparks, NVThe pilot's failure to follow the pre-takeoff checklist that resulted in the canopy opening during takeoff, which created a distraction, and his failure to maintain aircraft control during landing.