NTSB investigations, 2012
47 cases where the sequence of events included Unknown or undetermined.
Cases per year
| 2008 | 17 |
|---|---|
| 2009 | 31 |
| 2010 | 52 |
| 2011 | 44 |
| 2012 | 47 |
| 2013 | 43 |
| 2014 | 65 |
| 2015 | 82 |
| 2016 | 100 |
| 2017 | 83 |
| 2018 | 98 |
| 2019 | 83 |
| 2020 | 87 |
| 2021 | 95 |
| 2022 | 124 |
| 2023 | 152 |
| 2024 | 122 |
| 2025 | 120 |
| 2026 | 263 |
Where
Open the mapLatest cases
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
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '000' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '000' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 CEN13FA100Accident · 2 fatalField investigationFinal reportAerovodochody L-29 Delfin · Combine, TXThe airplane's impact with terrain for reasons that could not be determined during examination of the available evidence because of extensive impact damage and postimpact fire.NTSB ERA13FA071Accident · 1 fatalField investigationFinal reportGreen Gary E Thorp T-18 · Pahokee, FLThe descent and overstress of the airplane during the descent, which resulted in the in-flight breakup of the airplane.NTSB ERA13WA080Accident · 1 fatalForeign investigationPiper PA-25-260 · El Viento, ColombiaOn November 22, 2012, at 1705 Universal Coordinated Time (UTC), a Piper PA-25-260, Colombian registration HK588,operated by Fuminorte Ltda. Fumigaciones Aereas Norte, was substantially damaged when it collided with terrain during an agriculture spraying…NTSB WPR13FA037Accident · 2 fatalField investigationFinal reportCessna 421C · Shaver Lake, CAThe pilot's failure to regain airplane control following a sudden rapid descent during cruise, which resulted in an in-flight breakup. Contributing to the accident was the pilot's decision to make the flight with a failed vacuum pump, particularly at high…NTSB ERA13LA045Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R22 · Alexander City, ALThe pilot’s delayed decision to initiate an autorotation and her subsequent improper conduct of the autorotation, which resulted in a hard landing, after the helicopter started vibrating for reasons that could not be determined because postaccident…NTSB CEN13FA025Accident · Serious injuriesField investigationFinal reportAgusta AW139 · Houma, LAThe helicopter’s sudden and severe vertical vibrations during landing, which resulted in a collision with terrain. The reason for the helicopter’s sudden and severe vertical vibrations could not be determined during postaccident examinations.NTSB ERA13FA032Accident · 2 fatalField investigationFinal reportSwift Museum Foundation GC-1A · East Moriches, NYThe failure of the pilot to maintain airspeed, while attempting a precautionary landing for reasons that could not be determined from the available evidence. Contributing to the accident was the pilot’s pitch-up reaction to birds that took flight during his…NTSB ANC13FA004Accident · 1 fatalField investigationFinal reportGrumman Aircraft ENG C-1A · Willow, AKThe pilot’s loss of control of the airplane for reasons that could not be determined because the wreckage was not recovered from the accident site.NTSB CEN12LA669Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R44 · Nocona, TXThe noncertificated pilot’s operation of the helicopter, which resulted in impact with the water.NTSB WPR12LA417Accident · Minor injuriesLimited investigationFinal reportSeymour Skyranger · Perris, CAA loss of aircraft control during cruise flight for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB CEN12FA628Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Bullard, TXThe pilot's maneuver, which exceeded the airplane's structural limit and resulted in an in-flight breakup.NTSB WPR12LA411Accident · No injuriesLimited investigationFinal reportCessna A185F · Cambria, CAA partial loss of engine power during cruise flight for reasons that could not be determined because the airplane sank in the ocean and was not recovered.NTSB ERA12WA577Accident · 1 fatalForeign investigationCessna 172R · Macapá, BrazilOn September 12, 2012, about 2112 universal coordinated time, a Cessna 172R, Brazilian registration PT-WYK, was destroyed when it collided with terrain under unknown circumstances near Macapa ´, Brazil. The non-certificated pilot was fatally injured. The…NTSB WPR12LA383Accident · No injuriesLimited investigationFinal reportCessna 177RG · Olympia, WAA loss of directional control during landing for reasons that could not be determined because postaccident examination of the nose gear steering mechanism did not reveal any anomalies that would have precluded normal operation.NTSB CEN12WA562Accident · 2 fatalForeign investigationPiper PA-38-112 · Bruera, Cheshire, United KingdomOn August 16, 2012, about 1940 universal coordinated time, a Piper PA-38-112 airplane, United Kingdom registration G-BODP, impacted terrain during an instructional flight near Bruera, Cheshire, United Kingdom. The flight instructor and student pilot were…NTSB WPR12FA349Accident · 1 fatalField investigationFinal reportCessna P210N · Santa Monica, CAThe pilot's failure to maintain altitude during a return to the airport following an unspecified emergency; the nature of the emergency could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would…NTSB DCA12CA122Accident · No injuriesData collectionFinal reportAirbus A330 · Dulles, VAthe A330 flightcrew's failure to maintain a safe clearance between his wing and the tail of the DHC-8-400 that was stopped on the lead in line of the gate.NTSB CEN12WA528Accident · Serious injuriesForeign investigationCessna 180G · Kenora, CanadaNTSB CEN12LA495Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Lakeview, ARThe pilot’s loss of control during the takeoff roll for reasons that could not be determined because postaccident examination of the airplane did not reveal any anomalies that would have precluded normal operation.NTSB DCA12WA135Accident · 3 fatalForeign investigationAgusta A109 · Jiquipilco, MexicoThe Mexican Dirección General de Aeronáutica Civil (DGAC) has notified the NTSB of an accident involving a AgustaWestland 109SP helicopter that occurred on July 28, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC investigation…NTSB WPR12FAMS1Accident · 1 fatalMissing aircraftFinal reportJeffko Glasair · Tonasket, WAThe cause of the accident is undetermined as the airplane has not been located and remains missing.NTSB ERA12CA466Accident · No injuriesData collectionFinal reportCessna 172P · St. Augustine, FLUndetermined due to a lack of information about when the damage to the airplane occurred.NTSB CEN12LA455Accident · No injuriesLimited investigationFinal reportCessna 175A · Shelby, ILThe loss of engine power due to oil starvation for reasons that could not be determined because engine examinations revealed no malfunctions or failures that would have led to oil starvation.NTSB ERA12FAMS2Accident · 1 fatalMissing aircraftFinal reportCessna 150F · Atlantic Ocean (Atlantic Ocean)Undetermined (airplane and pilot missing).NTSB CEN12FAMS1Accident · 1 fatalMissing aircraftFinal reportPiper PA-31-325 · Duluth, MNUndetermined because the airplane was not found.NTSB CEN12LA352Accident · No injuriesLimited investigationFinal reportGrumman G164 · Higginson, ARThe partial loss of engine power for reasons that could not be determined due to impact and fire damage.NTSB WPR12LA314Accident · No injuriesLimited investigationFinal reportCessna 182R · Hilo, HIThe damage to the engine firewall for a reason that was undetermined because the damage was not reported when it occurred.NTSB ERA12WA383Accident · 1 fatalForeign investigationPiper PA-28R-200 · São Paulo, BrazilNTSB ERA12LA364Accident · 1 fatalLimited investigationFinal reportMoyes B/Bailey B Dragonfly · Trenton, GAThe airplane's entry into an uncontrolled descent for reasons that could not be determined because postaccident examination of the airplane did not reveal any anomalies that would have precluded normal operation and it could not be determined whether the…NTSB WPR12WA446Accident · 1 fatalForeign investigationHughes 369D · Lake Sumner, New Zealand, New ZealandOn May 21, 2012, at 0200 universal coordinated time, a Hughes 369D, ZK-HXZ, registered to and operated by Way to Go Heliservices, crashed into Lake Sumner, New Zealand, under unknown circumstances. The helicopter sank in 125 meters of water and was not…NTSB ERA12WA372Accident · 1 fatalForeign investigationCessna 182 · Veronica, ArgentinaOn May 19, 2012, about 2140 universal coordinated time, a Cessna 182C, Argentina registration LV-GTF, was substantially damaged when it impacted terrain during a missed approach at Veronica Airfield, Veronica, Buenos Aires, Argentina. The foreign certificated…NTSB DCA12WA085Incident · No injuriesForeign investigationBoeing 737 · Riga, LatviaOn May 19, 2012, at approximately 0819 locat time, a Boeing 737-500 operated by AirBaltic was climbing after departure from Riga International Airport, and was cleared by ATC to climb to FL230. At the same time, an Airbus 320, operated by Aeroflot perfromed a…NTSB WPR12FA216Accident · 2 fatalField investigationFinal reportAero Vodochody L-39 · Boulder City, NVAn in-flight emergency followed by a collision with terrain for reasons that could not be determined because postaccident examination of the airframe, engine, and forward and aft canopies revealed no evidence of mechanical malfunctions or failures that would…NTSB DCA12WA074Accident · No injuriesForeign investigationDornier 228 · Jomson, NepalThe Nepal Civil Aviation Authority (NCAA) has notified the NTSB of an accident involving a DO-228 that occurred on May 14, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the NCAA investigation under the provisions of ICAO Annex 13 as…NTSB WPR12TA445Accident · No injuriesFinal reportBeech C90 · Boise, IDExcessive loading on the left wing, which occurred over a period of time. Contributing to the accident was maintenance personnel’s failure to adequately inspect and document the left wing damage.NTSB ERA12WA353Accident · 2 fatalForeign investigationEmbraer EMB712 · Morro do Manduba Guaruja, BrazilOn April 26, 2012, about 1845 Universal Coordinated Time (UTC), an Embraer 712, Brazilian registration PT-NUH, operated by the Aeroclube de Itanhaem, crashed under unknown circumstances in a dense forest area in Morro do Manduba Guaruja Municipality, Sao…NTSB CEN12FA251Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Newcomerstown, OHThe pilot’s loss of airplane control in instrument meteorological conditions due to his distraction by electrical system anomalies, which resulted in an uncontrolled descent. The reason for the electrical system anomalies could not be determined.NTSB ERA12LA290Accident · 1 fatalLimited investigationFinal reportCessna 421CPilot incapacitation, which resulted in the pilot’s inability to maintain airplane control and the airplane’s subsequent ocean impact.NTSB WPR12LA160Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Kent, WAThe pilot’s failure to maintain airplane control while maneuvering in the traffic pattern, which resulted in a collision with trees.NTSB ERA12WA298Accident · 4 fatalForeign investigationAgusta A119 · Leningradsky, RussiaOn April 6, 2012, about 1240 Universal Coordinated Time (UTC), an AgustaWestland S.p.A., A119 helicopter, Russian registration RA-01980, crashed onto a frozen lake (Yanisyarvi), Sortavalsk district, Leningradsky region, about 5 KM from camp Chernye Kamni,…NTSB DCA12WA055Accident · No injuriesForeign investigationATR ATR72 · Roshchino, RussiaThe Russian Interstate Aviation Committee (MAK) has notified the NTSB of an accident involving an ATR-72 that occurred on April 2, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the MAK investigation under the provisions of ICAO Annex…NTSB ERA12WA249Accident · 8 fatalForeign investigationBeech 300 · Puerto Aguiree, ChileOn March 22, 2012, at 0358 UTC, a Beech BE 300, Chilean registration CC-AEB registered to Banco Popular Espanol, S.A. and operated by Inaer Helicopter Chile SA as an air ambulance flight, departed controlled flight at Flight level 280 while in radio contact…NTSB ERA12WA221Accident · 3 fatalForeign investigationPiper PA-34 · Belém, BrazilOn February 25, 2012, about 1150 coordinated universal time, a Piper PA-34-220T, Brazilian registration PR-LAB, was substantially damaged when it impacted terrain shortly after departure from Belém-Brigadeiro Protásio de Oliveira Airport (SBJC), Belém,…NTSB ERA12FA175Accident · 1 fatalField investigationFinal reportCessna T182T · Lebanon, NHThe pilot’s failure to maintain airspeed during a return to the airport after takeoff, which resulted in an aerodynamic stall and loss of airplane control.NTSB ERA12FA149Accident · 1 fatalField investigationFinal reportAero Vodochody L39C · Rainbow City, ALAn in-flight loss of control in instrument meteorological conditions.NTSB ERA12LA150Accident · No injuriesLimited investigationFinal reportM-Squared Breese 2 · Bayou La Batre, ALThe pilot's inability to maintain control of the airplane for reasons that could not be determined because postaccident examination of the rudder control system did not reveal any anomalies that would have precluded control of the airplane.NTSB CEN12WA138Accident · No injuriesForeign investigationPiper PA-31-235 · Powys, Wales, United Kingdom, United KingdomOn January 18, 2012, about 1145 universal time (UTC), a United Kingdom registered Piper PA-31-235, G-BWHF, sustained substantial damage when it impacted terrain near Leighton Welshpool, Powys, Wales, United Kingdom. The pilot and the passenger were fatally…