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 WPR09FA200Accident · 2 fatalField investigationFinal reportChampion 7ECA · San Jose, CAThe pilot's failure to maintain airspeed while maneuvering within a canyon in mountainous terrain, which resulted in an inadvertent stall/spin.NTSB WPR09CA207Accident · Serious injuriesData collectionFinal reportAerostar International Raven S49A · Tracy, CAThe pilot's failure to maintain clearance from the power lines.NTSB ERA09LA250Accident · 1 fatalLimited investigationFinal reportGladstone Kitfox · Dubre, KYThe pilot's failure to maintain airspeed while maneuvering at a low altitude, which resulted in an aerodynamic stall.NTSB ERA09CA255Accident · Serious injuriesData collectionFinal reportMartin Edward H Fire Star II · Church Hill, TNThe pilot's failure to maintain adequate airspeed to avoid an aerodynamic stall during final approach.NTSB ERA09CA252Accident · No injuriesData collectionFinal reportCessna/Air Repair 305F · Embden, METhe pilot's failure to obtain the proper touchdown point while landing.NTSB ERA09CA251Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Southbridge, MAThe pilot's inadequate compensation for the gusting wind conditions.NTSB CEN09LA256Accident · Serious injuriesLimited investigationFinal reportBoeing 737-724 · McAllen, TXThe injured passenger's failure to comply with the requirement to remain seated with a fastened seatbelt.NTSB WPR09LA201Accident · No injuriesLimited investigationFinal reportBrinker / Garner BI-PLANE · Caldwell, IDLoss of control during the landing roll for undetermined reasons.NTSB ERA09WA253Accident · 1 fatalForeign investigationCessna 208 · Canaima, VenezuelaNone.NTSB ERA09FA248Accident · 1 fatalField investigationFinal reportCessna 421B · Oakland Park, FLThe pilot's failure to maintain aircraft control and secure the right engine during an emergency return to the airport after takeoff. Contributing to the accident was an in-flight fire of the right engine for undetermined reasons.NTSB ERA09CA249Accident · No injuriesData collectionFinal reportBell 206 · West Palm Beach, FLThe pilot’s failure to maintain aircraft control during taxi, which resulted in a dynamic rollover.NTSB DCA09WA075Incident · No injuriesForeign investigationMcdonnell Douglas MD11 · Batco, ChileOn April 16, 2009, an Arrow Cargo, MD-11F, registration N384WA, experienced a left nosewheel separation during its approach to Arturo Merino Benitez Airport (SCEL), Santiago, Chile. There were no injuries to the 5 crew members onboard, and the airplane was…NTSB ANC09LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Talkeetna, AKThe pilot's failure to maintain adequate airspeed to avoid an aerodynamic stall while maneuvering at a high density altitude.NTSB WPR09LA204Accident · Minor injuriesLimited investigationFinal reportMaule M-5-235C · Los Angeles, CAThe pilot's inadequate compensation for the crosswinds and failure to maintain directional control during the landing roll.NTSB WPR09LA197Accident · No injuriesLimited investigationFinal reportRaytheon A36 · Lopez Island, WAA loss of engine power during cruise flight due to oil starvation. The oil starvation event was due to the failure of maintenance personnel to tighten the aft mounting nuts for the newly installed propeller governor and the pilot’s failure to secure the oil…NTSB WPR09CA199Accident · No injuriesData collectionFinal reportCessna A185F · Bisbee, AZThe flight instructor's inadequate supervision of the flight and inadequate recovery from a bounced landing.NTSB WPR09CA198Accident · Minor injuriesData collectionFinal reportBetter Burn LLC/Startube Div Exec 162F · Chandler, AZThe flight instructor's inadequate supervision of the flight and delay in taking remedial action to prevent the helicopter from touching down while drifting. Contributing to the accident was the design of the skid shoes.NTSB ERA09LA247Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Cross City, FLLoss of engine power for undetermined reasons.NTSB WPR09LA196Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Glendale, AZA loss of engine power due to the failure of both magnetos resulting from an improper maintenance repair by maintenance personnel.NTSB ERA09CA243Accident · Minor injuriesData collectionFinal reportCessna 150 · Madison, MSThe pilot's improper flare and subsequent loss of directional control.NTSB CEN09LA265Accident · Serious injuriesLimited investigationFinal reportT Bird T Bird II · Carlock, ILThe pilot's failure to gain sufficient altitude during the takeoff in order to avoid contacting the cameraman. Contributing to the accident was the pilot's lack of experience.NTSB CEN09LA250Accident · Minor injuriesLimited investigationFinal reportJordan Don R Vans RV-6A · Arlington, TXA total loss of engine power due to the failure of both magnetos. Contributing to the accident was the lack of preventative maintenance/inspection of the magnetos.NTSB CEN09CA251Accident · Minor injuriesData collectionFinal reportAviat A-1B · Great Bend, KSThe pilot's failure to maintain control of the airplane during takeoff in gusting wind conditions.NTSB ANC09LA032Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Anchorage, AKThe pilot's inability to maintain directional control due to the pilot's seat sliding back during takeoff as a result of maintenance personnel's incorrect installation of the seat's forward track stop.NTSB WPR09LA195Accident · Serious injuriesLimited investigationFinal reportSungkwon Kim LONG-EZE · Dunsmuir, CAThe loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to maintain aircraft control during the forced landing.NTSB WPR09CA194Accident · Minor injuriesData collectionFinal reportCessna 182A · Las Vegas, NVThe pilot's inadequate compensation for the gusty crosswind conditions while landing.NTSB ERA09CA242Accident · No injuriesData collectionFinal reportNorth American SNJ · Bessemer, ALThe pilot's failure to maintain aircraft control while landing with a crosswind.NTSB WPR09CA193Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Dubois, WYThe pilot's encounter with a windshear/downdraft that exceeded the climb performance capabilities of the airplane.NTSB ERA09WA241Accident · 4 fatalForeign investigationCessna 210 · Concepcion, BoliviaOn April 11, 2009, at 2305 universal coordinated time (1905 local time), a Cessna 210M, Bolivian registration CP-1373, was destroyed when it impacted terrain shortly after taking off from Concepcion Airport (SLCP), Concepcion, Bolivia. The certificated…NTSB ERA09CA404Accident · No injuriesData collectionFinal reportCessna 172 · York, PAThe student pilot's improper recovery from a bounced landing.NTSB CEN09CA249Accident · No injuriesData collectionFinal reportPiper J3C · Montrose, COThe pilot's failure to maintain directional control during the takeoff roll.NTSB ANC09LA031Accident · Serious injuriesLimited investigationFinal reportAerospatiale AS350 B2 E · Haines, AKThe pilot's failure to maintain clearance from snow-covered terrain during the landing approach in flat light conditions.NTSB ERA09LA244Accident · No injuriesLimited investigationFinal reportDe Havilland DHC2 · Plattsburgh, NYThe pilot's improper application of brakes during the landing rollout.NTSB ERA09IA240Incident · 1 fatalIncident investigationFinal reportBeech B200 · Fort Myers, FLThe pilot’s abnormal heart rhythm resulting in incapacitation.NTSB WPR09WA292Accident · No injuriesForeign investigationCessna 208 · Vientiane, Laos, LaosOn April 11, 2009, about 1035 coordinated universal time (UTC), a Cessna 208B, Laos registration RDPL-34144, owned by Helicopters of New Zealand, operated by Lao Air, was substantially damaged during a forced landing following a loss of engine power near…NTSB WPR09FA192Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · San Diego, CAThe pilot's failure to maintain control during an en route cruise descent through multiple cloud layers, resulting in an in-flight breakup.NTSB ERA09LA239Accident · Serious injuriesLimited investigationFinal reportDiamond DA20 · Shelbyville, TNA partial loss of engine power for an undetermined reason.NTSB ERA09CA245Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Tampa, FLThe pilot's failure to confirm that the landing gear was retracted prior to the attempted water landing.NTSB CEN09FA243Accident · 2 fatalField investigationFinal reportEngineering and Research 415C · Sandwich, ILThe pilot's failure to execute an immediate forced landing to a suitable field and the engine's partial loss of power for an undetermined reason.NTSB CEN09CA245Accident · No injuriesData collectionFinal reportCessna R182 · Granger, TXA loss of engine power due to fuel exhaustion as a result of the pilot's failure to visually verify that sufficient fuel was on board prior to flight.NTSB CEN09WA248Accident · 2 fatalForeign investigationPiper PA-28-181 · Steep, United KingdomNTSB ANC09LA030Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Nunapitchuk, AKThe pilot's failure to maintain sufficient airspeed to avoid a stall during the landing approach.NTSB WPR09CA191Accident · Serious injuriesData collectionFinal reportRemos Gemini Remos · Jefferson, WAThe pilot's inadequate compensation for the gusty crosswinds conditions while approaching to land.NTSB WPR09CA190Accident · Minor injuriesData collectionFinal reportAyres S2R-T34 · Cove, ORThe pilot's failure to maintain adequate clearance from rising terrain while maneuvering.NTSB WPR09CA186Accident · Minor injuriesData collectionFinal reportAir Creation Clipper 58 · Anacortes, WAThe partial loss of engine power due to the passenger's inadvertent movement of the engine throttle control.NTSB ERA09LA238Accident · No injuriesLimited investigationFinal reportByron J. Moore Zealot · Clermont, FLA loss of engine power due to oil starvation as a result of the previous owner's improper servicing of the engine oil.NTSB ERA09CA246Accident · No injuriesData collectionFinal reportPiper PA20 · Scranton, PAThe pilot’s inadequate compensation for wind conditions during landing. Contributing to the accident was the distraction of smoke in the cockpit.NTSB DCA09WA061Accident · 4 fatalForeign investigationCirrus SR-22 · Tizintichka, MoroccoOn April 9, 2009, about 1030 UTC, a Cirrus SR-22, a personal flight, collided with high terrain at an elevation of about 6700 feet, at Tizintichka, Morocco. Visual meteorological conditions prevailed and the airplane was on a VFR flight plan. The pilot and 3…NTSB DCA09WA043Accident · 6 fatalForeign investigationBAE Avro 146RJ · Wamena, Indonesia.NTSB CEN09LA247Accident · Serious injuriesLimited investigationFinal reportCessna 182T · Stigler, OKThe loss of directional control during takeoff. Contributing to the accident was the pilot's decision to take off with 40-degrees of flaps and with a tailwind.