NTSB investigations, 2012
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 ERA12LA417Accident · No injuriesLimited investigationFinal reportLuters Arnis V Legend · Glenwood, FLThe total loss of engine power due to the airplane builder’s improper installation of the fuel control unit condition lever cables, which resulted in the airplane’s subsequent forced landing.NTSB ERA12CA420Accident · No injuriesData collectionFinal reportCessna 172M · Smyrna, TNThe pilot’s inadequate flare and improper recovery from a bounced landing, which resulted in a hard landing.NTSB ERA12CA418Accident · Minor injuriesData collectionFinal reportGrumman American Avn. AA-1C · West Chester, PAThe pilot’s failure to maintain directional control during an attempted go-around, which resulted in a runway excursion.NTSB CEN12LA434Accident · No injuriesLimited investigationFinal reportBeech A36 · New Orleans, LAThe pilot's failure to lower the landing gear before touchdown.NTSB WPR12LA279Accident · Serious injuriesLimited investigationFinal reportBell UH-1F · Concrete, WAArcing of an energized electrical power line to the external long line and the conduct of electrical energy to ground personnel.NTSB ERA12CA419Accident · No injuriesData collectionFinal reportCessna 172S · West Palm Beach, FLThe flight instructor’s failure to maintain airplane control during the takeoff in gusting crosswind conditions. Contributing to the accident was the flight instructor’s decision to conduct takeoffs and landings in conditions exceeding the airplane’s maximum…NTSB CEN12WA397Accident · 2 fatalForeign investigationCessna 152 · Cascais, PortugalOn June 26, 2012, about 2135 coordinated universal time, a Cessna 152, Portuguese registration CS-AUR, sustained substantial damage when it impacted terrain near Cascais, Portugal. The pilot and one passenger were fatally injured. Night conditions prevailed…NTSB CEN12FA395Accident · 1 fatalField investigationFinal reportNappi Tito C Lancair 235M · Monroe Center, ILThe in-flight fire for a reason that could not be determined due to extensive damage from the fire.NTSB CEN12CA402Accident · No injuriesData collectionFinal reportSchweizer TH55A/269A · Grinnell, IAThe pilot’s inadequate compensation for the wind during a hovering maneuver, which resulted in a loss of tail rotor effectiveness and directional control.NTSB CEN12CA396Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Valparaiso, INThe pilot’s failure to stop the airplane while taxiing to park, which resulted in a collision with a parked vehicle.NTSB CEN12CA394Accident · Minor injuriesData collectionFinal reportBoeing B75N1 · Fredricksburg, TXThe pilot's excessive brake application, leading to a noseover during the landing. Contributing to the accident was the pilot’s delay in lowering the tail after landing.NTSB WPR12CA291Accident · No injuriesData collectionFinal reportStinson 108-2 · Mile Hi Landing Strip, IDThe pilot's misjudgment of the speed and distance required to land, which resulted in a runway overrun.NTSB ERA12FA412Accident · 1 fatalField investigationFinal reportSocata TB21 · Gold Hill, NCAn inflight fire, the origin of which could not be determined because of postaccident fire damage. Contributing to the accident was the pilot's improper modifications to the airplane.NTSB ANC12LA058Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Gustavus, AKThe fatigue failure of the engine crankshaft for reasons that could not be determined during postaccident metallurgical examination.NTSB WPR12LA292Accident · No injuriesLimited investigationFinal reportSikorsky S-58B · Brewster, WAAn in-flight fire during hover for reasons that could not be determined due to the extent of fire damage that subsequently consumed the structure.NTSB WPR12LA290Accident · No injuriesLimited investigationFinal reportBurleigh Bearhawk · Heber City, UTThe pilot’s failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB WPR12LA286Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Watsonville, CAA total loss of engine power during approach for reasons that could not be determined because postaccident examination did not reveal any mechanical malfunctions or failures that would have precluded normal operation.NTSB WPR12LA275Accident · No injuriesLimited investigationFinal reportDehavilland Tiger Moth DH 82A · Fontana, CAPartial loss of engine power during cruise flight due to a failed engine cylinder rocker assembly clamping bolt. Contributing to the accident was the failure of unknown maintenance personnel to perform a modification to the assembly that would have prevented…NTSB WPR12CA355Accident · No injuriesData collectionFinal reportAmerican Legend AL3 · Rexburg, IDThe student pilot's failure to maintain directional control and subsequent excessive braking during the landing roll with a tailwind, which resulted in a noseover.NTSB WPR12CA288Accident · Minor injuriesData collectionFinal reportDg-Flugzeugbau DG-500MB · Richland, WAThe failure of the spoilers to retract because the right wing spoiler’s lower plate became jammed, which resulted in the glider not having enough lift to make it to the runway surface.NTSB ERA12LA411Accident · 1 fatalLimited investigationFinal reportUniversal Stinson 108 · Portland, MEA fatigue failure of the No. 3 piston skirt, which resulted in a total loss of engine power and the subsequent ditching in the ocean.NTSB ERA12CA413Accident · Minor injuriesData collectionFinal reportMooney M10 · Hurlock, MDThe pilot's failure to see and avoid power lines during final approach to landing.NTSB CEN12LA404Accident · Serious injuriesLimited investigationFinal reportDestiny 2000 · Shelbyville, INThe operation of the aircraft by a non-certificated pilot and his failure to plan for the high density altitude and to maintain control of the aircraft.NTSB CEN12CA415Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Richmond, INThe pilot’s failure to ensure that the fuel selector was properly positioned, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR12LA289Accident · No injuriesLimited investigationFinal reportCox PA 18 · Soldier Bar, IDThe pilot’s failure to maintain directional control of the airplane during takeoff, which resulted in a runway excursion and the airplane nosing over.NTSB WPR12FA274Accident · 4 fatalField investigationFinal reportCessna 172 · Veneta, ORThe pilot’s failure to maintain adequate airspeed and altitude to clear trees during the initial climb after takeoff.NTSB ERA12CA414Accident · No injuriesData collectionFinal reportCessna 177 · West Milford, NJThe pilot's improper full flap retraction while performing a go-around maneuver, which resulted in a loss of airplane control.NTSB CEN12LA389Accident · No injuriesLimited investigationFinal reportHoyle Fighter Escort Wings · Pueblo, COAn internal failure of one of the electrical system’s two batteries combined with the inadequate electrical system design, which resulted in a total loss of engine power.NTSB CEN12LA388Accident · No injuriesLimited investigationFinal reportCessna A150K · Mamou, LAThe pilot's inadequate preflight inspection, which resulted in a partial loss of engine power due to fuel contamination.NTSB CEN12CA391Accident · No injuriesData collectionFinal reportLuscombe 8A · Mexico, MOThe airplane's encounter with a downdraft during the landing flare, which resulted in a hard landing.NTSB ANC12CA057Accident · No injuriesData collectionFinal reportChampion 7GCB · Tyonek, AKThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall while maneuvering.NTSB WPR12LA309Accident · No injuriesLimited investigationFinal reportBeech A36 · Rock Springs, WYThe total loss of engine power due to fuel starvation because of the incorrectly installed fuel cap. Contributing to the accident was the pilot’s decision to continue the flight using fuel from the left fuel tank after she observed fuel streaming from the…NTSB ERA12LA410Accident · No injuriesLimited investigationFinal reportPiper J5A · Atlantic Ocean (Atlantic Ocean)A loss of engine power for reasons that could not be determined because the aircraft sank after ditching and was not recovered.NTSB ERA12FA409Accident · 1 fatalField investigationFinal reportRaytheon C90GT · Morgantown, WVThe pilot's inadequate preflight route planning and in-flight route and altitude selection, which resulted in an in-flight collision with a communications tower in possible instrument meteorological conditions. Contributing to the accident were the pilot's…NTSB ERA12CA437Accident · No injuriesData collectionFinal reportCessna TR182 · Meridianville, ALThe pilot's inadequate landing flare, which resulted in a hard, bounced landing.NTSB CEN12LA456Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Metropolis, ILLanding gear collapse for reasons that could not be determined because testing could not replicate the problem.NTSB WPR12LA272Accident · No injuriesLimited investigationFinal reportCessna 150F · Jackson, CAThe student pilot's loss of directional control during landing, which resulted in a runway excursion.NTSB WPR12CA273Accident · No injuriesData collectionFinal reportCessna 170B · Concord, CAThe pilot’s failure to maintain control of the airplane while landing in gusting crosswind conditions.NTSB CEN12WA411Accident · 2 fatalForeign investigationCessna 150 · Strasswalchen, AustriaOn June 21, 2012, at 1332 UTC, a Reims Aviation F-150L, Austrian registration OE-ATV, was destroyed when it departed controlled flight and impacted terrain 3 miles east of Strasswalchen, Austria. The pilot and passenger on board were fatally injured. Visual…NTSB CEN12LA387Accident · No injuriesLimited investigationFinal reportCessna R182 · Santa Teresa, NMThe pilot’s failure to ensure that the landing gear was down and locked before landing.NTSB CEN12LA386Accident · Minor injuriesLimited investigationFinal reportCessna 140A · Walnut Ridge, ARThe pilot's failure to maintain aircraft control after encountering a whirlwind or dust-devil during the landing flare.NTSB CEN12CA399Accident · No injuriesData collectionFinal reportEdson Robert W Pietenpol AIR Camper · Point Lookout, MOThe pilot's failure to maintain directional control during landing, resulting in a ground-loop.NTSB ANC12CA081Accident · No injuriesData collectionFinal reportPiper J3F-65 · Beluga, AKThe pilot's delayed decision to go around, which resulted in a hard landing.NTSB WPR12CA308Accident · No injuriesData collectionFinal reportCessna 180A · Cascade, IDThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR12CA271Accident · Serious injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Okanogan, WAThe pilot's failure to maintain clearance from power lines while maneuvering.NTSB ENG12WA029Incident · No injuriesForeign investigationAirbus A320 · Auckland, New Zealand, New ZealandOn 20 June 2012, an Airbus A320 (Registration ZK-OJQ) operated by Air New Zealand suffered a bird-strike on its right-hand engine on approach to Wellington Aerodrome (New Zealand). The aircraft landed safely, after which Air New Zealand Maintenance carried…NTSB DCA12WA099Incident · No injuriesForeign investigationBoeing 737 · Taoyuan, TaiwanThe Taiwan Aviation Safety Council (ASC) has notified the NTSB of an accident involving a Boeing 737 that occurred on June 20th, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the ASC investigation under the provisions of ICAO Annex…NTSB DCA12WA097Accident · No injuriesForeign investigationBoeing 767 · Tokyo, JapanThe Japan Transport Safety Board (JTSB) has notified the NTSB of an accident involving a Boeing 767-300 that occurred on June 20, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the JTSB investigation under the provisions of ICAO Annex…NTSB ANC12LA056Accident · Serious injuriesLimited investigationFinal reportHelio H-295-1400 · Deadhorse, AKThe pilot's failure to extend the airplane’s wing flaps before takeoff and her selection of an unsuitable takeoff area, which resulted in a collision with a concrete loading ramp during the aborted takeoff.NTSB ANC12CA059Accident · No injuriesData collectionFinal reportDosser Dale A Blade 582 · Two Rivers, AKThe total loss of engine power during cruise flight due to fouled spark plugs, which resulted from a stuck mixture control.