NTSB investigations, 2012
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 WHERE year(c.\"eventDate\") = 2012 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 WHERE year(c."eventDate") = 2012 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 WPR12CA077Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · San Diego, CAThe pilot's inadequate directional control during the landing roll.NTSB ERA12WA159Accident · 3 fatalForeign investigationBeech A36 · Mato Grosso, BrazilOn January 14, 2012, about 1000 universal coordinated time, a Beech A36, Brazilian registration PR-RGF, was destroyed when it impacted terrain, following a loss of control during cruise flight into deteriorating weather near Mato Grosso, Brazil. The…NTSB DCA12WA027Incident · No injuriesForeign investigationBoeing 777 · Rio de Janeiro, BrazilThe Brazilian Centro de Investigação e Prevenção deAcidentes Aeronáuticos (CENIPA) has notified the NTSB of an incident involving a Boeing 777 that occurred on January, 14, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the CENIPA…NTSB CEN12LA134Accident · Minor injuriesLimited investigationFinal reportAero Commander 500-B · Bartlesville, OKThe total loss of engine power due to fuel exhaustion and the pilot’s inadequate preflight inspection, which did not correctly identify the airplane’s fuel quantity before departure.NTSB CEN12LA135Accident · No injuriesLimited investigationFinal reportCessna 150M · El Dorado, KSThe loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN12CA136Accident · No injuriesData collectionFinal reportMooney M20K · Willmar, MNThe pilot landed without lowering the landing gear.NTSB CEN12LA133Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Denmark, WIThe pilot’s loss of control due to his alcohol impairment. Contributing to the accident was the pilot's decision to fly at night with a known interior lighting malfunction.NTSB ERA12FA143Accident · Serious injuriesField investigationFinal reportCessna 150G · Fitchburg, MAA partial loss of engine power due to the formation of carburetor ice and the flight instructor's improper application of carburetor heat.NTSB CEN12CA131Accident · Serious injuriesData collectionFinal reportInfinity Power Parachutes Classic 2002 · Alanson, MIThe powered parachute’s encounter with a downdraft/windshear during takeoff, which resulted in a loss of lift.NTSB DCA12WA025Incident · No injuriesForeign investigationBoeing 737 · Fort Nelson, CanadaThe Transportation Safety Board of Canada (TSB) has notified the NTSB of an accident involving a Boeing 737 that occurred on January 9, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the TSB investigation under the provisions of ICAO…NTSB WPR12LA097Accident · No injuriesLimited investigationFinal reportBeech 58P · Santa Ana, CAThe pilot’s failure to review or execute any applicable checklist procedures or troubleshoot or take corrective action before landing despite indications that the landing gear was not extended. Contributing to the accident were the pilot’s misunderstanding of…NTSB ERA12LA141Accident · 1 fatalLimited investigationFinal reportBowers Fly Baby 1-A · Jefferson, GAThe pilot’s failure to maintain airplane control which resulted in an aerodynamic stall and spin. Also causal was the partial loss of engine power during the initial climb due to the improper installation of a magneto. Contributing to the accident was the…NTSB CEN12WA504Accident · 2 fatalForeign investigationCessna 152 · Moisselles, FranceOn January 8, 2012, about 1615 UTC, a Cessna 152, French registration F-GLPO, operated by Aero-Club Les Ailerons d'Enghien-Moisselles, was substantially damaged when it abruptly dove toward the ground and crashed on the Enghien-Moisselles Airfield,…NTSB ERA12WA142Accident · No injuriesForeign investigationCirrus Design SR22 · Andros Island, BahamasOn January 7, 2012, about 1324 eastern standard time, a Cirrus Design Corp. SR22, N723EA, registered to and operated by M&W Aviation LLC, descended into water near Andros Island, Bahamas, following deployment of the Cirrus Airframe Parachute System (CAPS).…NTSB ERA12CA140Accident · No injuriesData collectionFinal reportLuscombe 8A · Umatilla, FLA failure of the left main landing gear due to a preexisting crack and corrosion, which resulted in a loss of directional control during landing.NTSB DCA12WA103Incident · No injuriesForeign investigationBoeing 737-800 · Stockholm, SwedenOn January 7, 2012, the left winglet of a Boeing 737-800, TC-SNM, operated by SunExpress, impacted the right horizontal stabilizer of a parked airplane while taxiing at the Arlanda Airport (ARN), Stockholm, Sweden. There were no reported injuries to the…NTSB DCA12WA026Incident · No injuriesForeign investigationRiga, LatviaOn January 7, 2012, at about 1905 local time, a Boeing 737-8AS, registration EI-DHI, serial # 33818, operated by Ryanair, experienced a failure of the No. 2 pitot heater, without any associated warnings, leading to multiple failure indications. The flight was…NTSB WPR12LA076Accident · No injuriesLimited investigationFinal reportPiper PA28 · Phoenix, AZThe pilot’s inability to maintain directional control during the landing roll for reasons that could not be determined because impact damage precluded determination of the preaccident functionality of the braking and steering systems.NTSB WPR12LA074Accident · No injuriesLimited investigationFinal reportCzech Sportplanes Sro Dynamic WT9 · Glendale, AZThe pilot did not shut down the engine upon recognizing a brake malfunction. Contributing to the accident was the airplane's brake malfunction for undetermined reasons.NTSB ERA12CA137Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · St Petersburg, FLThe flight instructor's delayed remedial action during the pilot-receiving-instruction's practice autorotation that developed a high rate of descent. Contributing to the accident was the pilot-receiving-instruction's improper control inputs during the…NTSB CEN12WA144Accident · No injuriesForeign investigationRobinson R22 · Lincolnshire, United KingdomOn January 6, 2012, about 1127 universal time (UTC), a United Kingdom registered Robinson R22 Beta, G-CHZN, sustained substantial damage when it impacted terrain near Witchford, Cambridgeshire, United Kingdom. The pilot was fatally injured. The investigation…NTSB CEN12LA129Accident · Minor injuriesLimited investigationFinal reportAviat A-1C-180 · Chetek, WIThe passenger’s interference with the flight controls, which resulted in the airplane’s failure to climb after an aborted landing. Contributing was the pilot's failure to maintain directional control during landing roll, which resulted in the need to abort…NTSB CEN12LA126Accident · No injuriesLimited investigationFinal reportAviat A1 · Somerset, COThe pilot's inadequate takeoff planning/preparation, which resulted in the airplane impacting a snow drift during the takeoff roll.NTSB WPR12LA075Accident · No injuriesLimited investigationFinal reportPiper Aerostar 601P · Las Vegas, NVThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB CEN12LA128Accident · No injuriesLimited investigationFinal reportSanderson Pitts Special SPS-1 · Revere, MNThe total loss of engine power during cruise flight due to fuel contamination and the inadequate design of the fuel system.NTSB CEN12TA122Accident · No injuriesFinal reportCessna 172P · Conroe, TXFailure of the rear crankshaft gear dowel pin due to improper installation, which resulted in a total loss of engine power.NTSB CEN12LA124Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · San Angelo, TXA loss of engine power for undetermined reasons.NTSB CEN12CA121Accident · No injuriesData collectionFinal reportButler John R SX 300 · Truth or Consequences, NMThe pilot did not maintain airplane control during takeoff due to his distraction with the improperly secured canopy, which he forgot to latch.NTSB WPR12CA073Accident · No injuriesData collectionFinal reportMcadam W E Christen Eagle II · Eureka, CAA collision with a deer while landing.NTSB ERA12LA132Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Shelter Island, NYA hard landing, which resulted in a failure of the right main and collapse of the left main landing gear.NTSB ERA12CA134Accident · No injuriesData collectionFinal reportMaule M-5-180C · River Ranch, FLThe pilot’s failure to maintain directional control after encountering a wind gust during landing.NTSB CEN12CA132Accident · No injuriesData collectionFinal reportPiper PA-18-135 · Del Norte, COThe pilot's loss of directional control during the landing roll, which resulted in a runway excursion. Contributing to the accident were the sensitivity of the brake system and the certified flight instructor pilot's delayed remedial action.NTSB ERA12LA131Accident · No injuriesLimited investigationFinal reportHaney John F B Seastar XP · Willimantic, CTA partial loss of engine power due to carburetor icing. Contributing to the accident was the lack of an installed manufacturer-recommended carburetor heat system.NTSB CEN12LA120Accident · Serious injuriesLimited investigationFinal reportContinental Copters 47G2 · Lohn, TXThe improper installation of the tail rotor gearbox by maintenance personnel, which led to accelerated wear of the ring and pinion gears, resulting in the loss of tail rotor effectiveness and subsequent forced landing.