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 ERA10LA019Accident · Serious injuriesLimited investigationFinal reportRobinson R44 · La Belle, FLThe loss of main rotor rpm due to the failure of one or more of the drive belts for undetermined reasons.NTSB CEN10WA016Accident · 3 fatalForeign investigationEurocopter EC120B · San José de Ocoa, Dominican RepublicNTSB CEN10LA014Accident · No injuriesLimited investigationFinal reportCessna T210L · Albuquerque, NMThe mechanic's failure to find and repair a leaking main landing gear hydraulic line during an annual inspection.NTSB CEN10FA019Accident · 2 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Tahlequah, OKThe pilot's impairment due to recent heavy use of methamphetamine, recent use of a narcotic pain reliever, and fatigue. Contributing to the accident was the pilot's lack of instrument experience and training.NTSB ANC10FA004Accident · 1 fatalField investigationFinal reportCessna A185E · Healy, AKThe pilot's decision to maneuver at a low altitude over rising terrain in conditions conducive to turbulence/downdrafts, resulting in a loss of control and impact with terrain.NTSB WPR10FA018Accident · 2 fatalField investigationFinal reportCessna 182 · Pryor, MTThe pilot’s decision to continue flight into an area of low ceilings and low visibility and his failure to maintain clearance from terrain.NTSB ERA10CA016Accident · Minor injuriesData collectionFinal reportPiper PA28 · Meadville, PAA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning.NTSB WPR10TA016Accident · Minor injuriesFinal reportMD Helicopter 600 · San Diego, CAThe pilot's failure to maintain adequate main rotor rpm during an autorotation, which resulted in a hard landing.NTSB WPR10FA012Accident · 1 fatalField investigationFinal reportMcdonnell Douglas Heli 369FF · Fossil, ORThe pilot's failure to maintain clearance from a power pole to which he was connecting wire-pulling ropes.NTSB WPR10CA017Accident · No injuriesData collectionFinal reportCessna 182F · Elko, NVThe pilot's failure to maintain directional control while taking off in known gusty wind conditions.NTSB WPR10FA223Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D1 · Skokomish, WAThe pilot's failure to maintain clearance from trees while flying over hilly, forested terrain.NTSB WPR10CA015Accident · Serious injuriesData collectionFinal reportLet Blanik L-13 · Llano, CAThe student pilot's improper use of the airbrakes while on approach for landing.NTSB ERA10GA015Accident · No injuriesFinal reportBell OH-58A · Ocala, FLThe excessive wear and failure of engine governor components for undetermined reasons, which resulted in a loss of engine power.NTSB CEN10LA012Accident · Serious injuriesLimited investigationFinal reportLuscombe 8E · Weeping Water, NEThe pilot’s failure to maintain aircraft control resulting in a stall. Contributing to the accident was the stuck exhaust valve resulting in the partial loss of engine power.NTSB WPR10LA014Accident · No injuriesLimited investigationFinal reportCostruzioni Aeronautiche Tecna P2004 Bravo · Franklin, CAA total loss of engine power due to fuel starvation, as a result of the certified flight instructor's improper fuel system management.NTSB WPR10CA026Accident · No injuriesData collectionFinal reportCessna 180A · Condon, ORThe pilot's failure to maintain clearance from the fence post on approach.NTSB WPR10CA013Accident · No injuriesData collectionFinal reportCessna 172H · Tucson, AZThe pilot's failure to maintain directional control during the takeoff ground roll.NTSB ERA10LA014Accident · Serious injuriesLimited investigationFinal reportBeech E35 · Mount Morris, NYThe pilot’s improper decision to take off from unsuitable terrain with a quartering tailwind.NTSB ERA10LA013Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Marathon, FLA total loss of engine power for undetermined reasons.NTSB ERA10CA017Accident · Serious injuriesData collectionFinal reportPiper PA28 · Lebanon, VAThe pilot’s decision to continue flight under visual flight rules into known deteriorating weather conditions, which resulted in controlled flight into terrain.NTSB CEN10FA011Accident · 2 fatalField investigationFinal reportCessna 150F · Alexandria, LAFailure of the wingman to maintain proper separation from the lead airplane during formation maneuvers. Contributing to the accident was lead's abrupt right bank and both pilots' lack of formation training.NTSB ANC10CA002Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Nondalton, AKThe pilot's decision to attempt a landing in weather conducive to strong downdrafts, resulting in a loss of control.NTSB WPR10LA010Accident · 1 fatalLimited investigationFinal reportCruz SE5A Replica · Phoenix, AZThe pilot's failure to maintain airspeed during initial climb, which resulted in a stall/spin and impact with the ground.NTSB CEN10CA020Accident · No injuriesData collectionFinal reportFranklin Pitts Special S-1 · Alamosa, COThe pilot’s failure to maintain directional control on takeoff.NTSB CEN10CA013Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Bingham, NEThe pilot's impairment due to alcohol consumption and failure to maintain aircraft control.NTSB WPR10FA009Accident · 1 fatalField investigationFinal reportPiper PA-12 · Burlington, WAThe pilot's in-flight loss of control due to his failure to correctly connect the elevator control cables during the restoration/rebuild of the airplane. Contributing to this accident was the pilot's decision to perform a high-speed taxi test prior to having…NTSB WPR10CA011Accident · No injuriesData collectionFinal reportCessna 180 · Pistol Creek, IDThe separation of one of the airplane's main landing gear legs during landing in variable gusting wind conditions, due to the nut being stripped from the attachment bolt.NTSB ERA10CA011Accident · No injuriesData collectionFinal reportRemos Remos G-3/ · Sims, NCThe pilot's failure to maintain altitude, resulting in controlled flight into water.NTSB ERA10CA010Accident · No injuriesData collectionFinal reportSchweizer 269C-1 · Lewiston, METhe loss of tail rotor effectiveness (LTE) resulting from hovering the helicopter in a tailwind.NTSB CEN10CA017Accident · Serious injuriesData collectionFinal reportCameron Z77 · Albuquerque, NMThe pilot’s failure to maintain control of the balloon during the approach and landing.NTSB CEN10CA015Accident · Serious injuriesData collectionFinal reportAerostar International RX8 · Albuquerque, NMThe pilot’s failure to select an adequate landing area.NTSB ANC10CA003Accident · No injuriesData collectionFinal reportCessna U206F · Homer, AKAn in-flight collision with a bird.NTSB WPR10CA008Accident · No injuriesData collectionFinal reportCessna 172P · Renton, WAThe failure of the student pilot to maintain directional control during the takeoff portion of a touch-and-go landing resulting in a collision with a sign.NTSB WPR10CA007Accident · No injuriesData collectionFinal reportCessna 172N · San Diego, CAThe pilot’s improper flare and inadequate recovery from a bounced landing.NTSB ERA10CA008Accident · No injuriesData collectionFinal reportCessna 172S · Easton, PAThe pilot’s failure to maintain adequate clearance from terrain while on short final.NTSB CEN10FA007Accident · Serious injuriesField investigationFinal reportBeech 100 · Aurora, TXThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel management.NTSB WPR10LA006Accident · Serious injuriesLimited investigationFinal reportTurpen RV-8 · Yankton, ORThe pilot's inadequate planning during an instrument approach and failure to maintain the published minimum altitudes, which resulted in controlled flight into terrain.NTSB ERA10LA007Accident · 1 fatalLimited investigationFinal reportCase Richard L VAN RV-6 · Magnolia, NCThe pilot's continued visual flight into instrument meterological conditions and his subsequent failure to maintain aircraft control. Contributing to the accident was the pilot's inadequate preflight evaluation of the weather.NTSB ERA10CA022Accident · Serious injuriesData collectionFinal reportBoeing 767-3P6 · ArgentinaAn inadvertent encounter with turbulence, which resulted in an injury to a flight cabin attendant.NTSB ERA10CA006Accident · Serious injuriesData collectionFinal reportPiper PA-28-140 · Gainesboro, TNThe pilot's failure to maintain clearance from trees. Contributing to the accident were the rising terrain and night light conditions.NTSB CEN10LA004Accident · Serious injuriesLimited investigationFinal reportTemco D-16A · Eden Prairie, MNA total loss of left engine power due to fuel starvation as a result of the failure of the engine's electric fuel pump end cap gasket, which allowed air to be drawn into the fuel system.NTSB CEN10CA010Accident · Serious injuriesData collectionFinal reportAerostar International RX-7 · Albuquerque, NMThe pilot’s failure to maintain adequate clearance from a known obstacle and the pilot’s failure to maintain control of the balloon during the sudden climb following the ejection of the passenger.NTSB ANC10CA001Accident · No injuriesData collectionFinal reportDehavilland DHC-2 · King Salmon, AKThe pilot's selection of an unsuitable takeoff area, and his decision to takeoff with a tailwind.NTSB WPR10FA005Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Black Canyon City, AZThe pilot's decision to continue VFR flight into instrument meteorological weather conditions which resulted in controlled flight into terrain. Contributing to the accident were low ceilings, reduced visibility, and mountainous terrain.NTSB ERA10LA005Accident · No injuriesLimited investigationFinal reportCessna 210 · Louisville, KYA malfunction of the landing gear extension system due to a fractured hydraulic line. Contributing to the accident was the inadequate inspection and maintenance of the hydraulic line.NTSB ENG10WA018Incident · No injuriesForeign investigationSaab 340 · Wagga Wagga, New South Wales, AustraliaOn 4 October 2009, at 1257 EST, a SAAB 340B aircraft, registered VH-SBA, experienced a failure of the left engine during initial climb out from Wagga Wagga Aerodrome, NSW, Australia on a regular scheduled flight to Melbourne, Victoria, Australia. The flight…NTSB WPR10WA036Accident · 1 fatalForeign investigationAir Tractor AT-502 · Narrogin, Australia, AustraliaOn October 3, 2009, at 1130 Western Standard Time, an Air Tractor AT-502, VH-ODP, operated by Agricair Pty Limited, as an agricultural flight collided with the ground while maneuvering 47 Km east northeast of Narrogin, Australia. Visual meteorological…NTSB WPR10LA004Accident · No injuriesLimited investigationFinal reportCessna 172A · Payson, AZThe stress corrosion cracking of the nose gear landing fork, which resulted in the fork's failure during landing.NTSB WPR10LA003Accident · Minor injuriesLimited investigationFinal reportMateskon Fisher DAK · Bozeman, MTA loss of engine power due to shearing of the crankshaft gear cluster bolts. Contributing to the accident was the lack of regular overhaul periods as recommended by the engine manufacturer.NTSB WPR10LA002Accident · No injuriesLimited investigationFinal reportCessna 421B · San Simeon, CAThe pilot's failure to follow the manufacturer’s checklist and set the parking brake.