NTSB investigations
1,713 cases where the sequence of events included Unknown or undetermined.
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 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 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 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…NTSB CEN12FA072Accident · 4 fatalField investigationFinal reportPiper PA-28-180 · Perryville, ARThe pilot's loss of control in flight.NTSB ERA12IA060Incident · No injuriesIncident investigationFinal reportCessna 550 · Key West, FLThe pilots’ failure to appropriately apply the landing gear wheel brakes after landing, to properly perform the hard brake pedal-no braking condition procedure following the reported brake failure and to apply the emergency brakes. The reason for the reported…NTSB ERA12FA057Accident · 1 fatalField investigationFinal reportEckenrode Carl J Vans RV-6 · Taylorsville, GAThe airplane's entry into an uncontrolled descent for reasons that could not be determined because postaccident examination of the airplane and the pilot’s medical history did not reveal any anomalies that would have precluded normal operation.NTSB CEN12LA047Accident · Serious injuriesLimited investigationFinal reportSaber Trike unk · Okmulgee, OKThe in-flight collision with electrical wires for undetermined reasons.NTSB ERA12FA051Accident · 1 fatalField investigationFinal reportCessna 150F · Moncks Corner, SCThe debilitating effects of ethylene glycol poisoning, which resulted in the pilot’s inability to maintain control of the airplane.NTSB CEN12FA001Accident · 1 fatalField investigationFinal reportRobinson Helicopter R66 · Philip, SDThe in-flight separation of the main rotor mast following a mast bumping event. The reason for the mast bumping event could not be determined due to postaccident damage.NTSB DCA11WA108Accident · 18 fatalForeign investigationAviocar CASA C212 · Aceh, IndonesiaThe National Transportation Safety Committee of Indonesia (KNKT) has notified the NTSB of an accident involving a Aviocar CASA C212 that occurred on September 29, 2011. The NTSB has appointed a U.S. Accredited Representative to assist the KNKT investigation…NTSB WPR11WA476Accident · 2 fatalForeign investigationBell 412SP · Mataram, West Nusa, IndonesiaOn September 25, 2011, at 1341 local time (0541 UTC) a Bell Helicopter 412SP, Indonesia registry PK-OVC, crashed in a jungle under unknown circumstances 150 kilometers east of Selaparang Airport, Mataram, West Nusa Tenggara, Indonesia. The Helicopter was…NTSB DCA11WA099Incident · No injuriesForeign investigationAirbus A320 · Cusco, PeruOn September 19, 2011, at 1620 UTC, an Airbus A320-233, N493TA, experienced smoke in the cockpit. The airplane landed uneventfully at Alejandro Velasco Astete International Airport (SPZO), Peru, its original destination. None of the passengers or crewmembers…NTSB CEN11WA639Accident · 2 fatalForeign investigationPiper PA-31P · Ciudad Apodaca, MexicoNTSB ERA11WA509Accident · 2 fatalForeign investigationRobinson R44 · Rio de Janeriro, BrazilOn September 10, 2011, about 2330 universal coordinated time, a Robinson R44 II, Brazilian registration PR-CEC, was substantially damaged when it impacted wooded terrain during an aerial photography flight, near Rio de Janeiro, Brazil. The foreign…NTSB WPR11FA429Accident · 1 fatalField investigationFinal reportBrewster LONG-EZ · Kanab, UTThe pilot's loss of airplane control during cruise flight.NTSB CEN11WA603Accident · 1 fatalForeign investigationCessna TU206G · Sioux Lookout, CanadaNTSB CEN11CA662Accident · No injuriesData collectionFinal reportPiper PA-30 · Saguache, COThe pilot's failure to maintain airplane control during the aborted takeoff.NTSB CEN11WA695Accident · 6 fatalClass 5 · ForeignCessna 210K · (Atlantic Ocean)NTSB ERA11LA501Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Monmouth, MEOperation of the airplane by a non-certificated pilot and his failure to maintain airplane control.NTSB ANC11LA080Accident · 2 fatalLimited investigationFinal reportPiper PA-18-150 · Cape Yakataga, AKA collision into water during initial climb after takeoff for undetermined reasons.NTSB WPR11WA351Accident · 1 fatalForeign investigationRobinson R22 · Fitzroy Crossing, Australia, AustraliaOn July 27, 2011, at 0930 universal coordinated time, a Robinson R-22 Beta, VH-YOL, registered to and operated by a private owner, collided with terrain near Fitzoy Crossing, Australia. The helicopter was substantially damaged and the pilot, the sole…NTSB CEN11LA504Accident · No injuriesLimited investigationFinal reportQuasar Acft 214SL · Fort Worth, TXA fuel leak in the engine compartment, which resulted in an engine fire.NTSB WPR11LA307Accident · Minor injuriesLimited investigationFinal reportStinson 108-2 · Columbia, CAThe airplane’s failure to climb at a sufficient rate to clear trees and terrain beyond the end of the runway for reasons that could not be determined because postaccident examination did not reveal any mechanical malfunctions or failures that would have…NTSB CEN11CA445Accident · Minor injuriesData collectionFinal reportSkytrails Lsa Predator · Coldspring, TXThe pilot's inadequate consideration of obstructions on his flight path and inability to maintain altitude following an unexplained loss of lift.NTSB CEN11LA449Accident · Minor injuriesLimited investigationFinal reportAbbey Victor RV9-A · Leander, TXThe partial loss of engine power for reasons that could not be determined because examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB WPR11LA272Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Hogeland, MTCollision with the ground while maneuvering at low altitude for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB CEN11LA385Accident · No injuriesLimited investigationFinal reportWiley C W RV-6A · Colgate, OKThe loss of engine power for undetermined reasons.NTSB WPR11FA256Accident · 3 fatalField investigationFinal reportBellanca 17-31ATC · Ukiah, ORThe non-instrument-rated pilot's decision to conduct a visual flight rules flight over mountainous terrain into a region covered by clouds, which likely resulted in spatial disorientation and subsequent loss of airplane control.NTSB CEN11WA382Accident · 1 fatalForeign investigationAir Tractor AT-502B · La Fora, Tiquisate, GuatemalaNTSB ERA11WA310Accident · 4 fatalForeign investigationPiper PA-34-200 · Sao Pedro, BrazilOn May 16, 2011, about 0130 universal coordinated time, a Piper PA-34-200, Brazilian registration PT-IFS, was destroyed when it impacted hilly terrain under unknown circumstances near Sao Pedro, Sao Paulo, Brazil. The Brazilian certificated pilot and three…NTSB ERA11WA305Accident · 3 fatalForeign investigationCessna 210M · Breu Branco, BrazilOn May 14, 2011, about 1430 universal coordinated time, a Cessna 210M, Brazilian registration PR-HSM, was substantially damaged when it impacted wooded terrain under unknown circumstances, in a remote, dense forest near Breu Branco, Brazil. The foreign…NTSB ERA11FA299Accident · 1 fatalField investigationFinal reportPiper PA-22-150 · Benezette, PAThe pilot's loss of airplane control for reasons that could not be determined from the available evidence.NTSB ERA11FA293Accident · Serious injuriesField investigationFinal reportBeech F33A · Tarentum, PAThe pilot's delay in aborting the takeoff, which resulted in a runway overrun. Contributing to the accident was the pilot's inadequate preflight planning and excessive loading of the airplane.NTSB ANC11WA028Accident · 1 fatalForeign investigationCessna 195A · Campbell River, CanadaNTSB CEN11LA308Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Streetman, TXThe airplane’s inability to establish a climb for undetermined reasons, which resulted in a collision with trees.