Skip to content

NTSB investigations

70 cases where the first occurrence was “Undetermined”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

Where

Latest cases

Query with SQL

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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 400) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 400)
  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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 400)
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 CHI07FA286Accident · 2 fatalField investigationFinal reportYakovlev Yak 52 · Lake-in-Hills, ILThe airplane descended and impacted terrain during initial climb for undetermined reasons. Contributing to the accident was the soft, uphill terrain.Sep 3, 2007 · N212YA · Substantial damage NTSB CHI07FA279Accident · 2 fatalField investigationFinal reportSocata TB-20 Trinidad · Pointe Aux Pins, MIUndetermined.Aug 24, 2007 · N96DF · Substantial damage NTSB LAX06CA039Accident · No injuriesData collectionFinal reportCessna 182T · Livermore, CAsubstantial damage to the airplane during unknown phase of flight for undetermined reasons.Oct 30, 2005 · N51732 · Substantial damage NTSB DCA05IA072Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2D15 · colorado spring, COUndetermined.Jun 10, 2005 · CGJAZ · No damage NTSB LAX05LA227Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Phoenix, AZsubstantial damage to the airplane during an unknown phase of flight for undetermined reasons.Mar 11, 2005 · N2882R · Substantial damage NTSB CHI05FA063Accident · 4 fatalField investigationFinal reportBeech BE-58 · Niles, MIThe steep nose down descent from cruise for undetermined reasons and the subsequent collision with terrain in a steep nose down attitude.Feb 4, 2005 · N12AZ · Destroyed NTSB DFW05LA069Accident · 1 fatalLimited investigationFinal reportNolen Lite Squared · Holdenville, OKUndeterminedJan 14, 2005 · N222JN · Destroyed NTSB FTW04FA186Accident · 1 fatalField investigationFinal reportBell 206 L-1 · Cameron, LAThe helicopter's in-flight collision with water for undetermined reasons.Jul 17, 2004 · N1078C · Destroyed NTSB MIA03LA012Accident · 2 fatalLimited investigationFinal reportPiper PA-46-350P · Memphis, TNThe cause of the accident is unknown as the airplane has not been located. A finding in the investigation was the fact that the pilot conducted an unstabilized approach; the flight was right, left, then right of the final approach course during the approach…Nov 3, 2002 · N167MA · Destroyed NTSB SEA02LA037Accident · 2 fatalLimited investigationFinal reportMooney M20C · Netarts, ORReason for occurrence undetermined.Dec 11, 2001 · N5774Q · Destroyed NTSB CHI01LA236Accident · Serious injuriesLimited investigationFinal reportChampion 7KCAB · Brooklyn, MIThe forced landing for undetermined reasons. A factor to the accident was the corn crop.Jul 22, 2001 · N7537F · Substantial damage NTSB CHI01FA111Accident · 1 fatalField investigationFinal reportCessna 501 · Ashwaubenon, WIThe pilot not maintaining aircraft control while maneuvering after takeoff and the pilot's inadequate preflight planning and preparation. Factors relating to the accident were the pilot's diverted attention while maneuvering after takeoff, the pilot's…Apr 2, 2001 · N405PC · Destroyed NTSB MIA00FA208Accident · 1 fatalField investigationFinal reportCessna 402C · Vieques, PRThe airplanes entry into an uncontrolled descent for undetermined reasons from which it crashed into the ocean.Jul 8, 2000 · N405MN · Destroyed NTSB DCA00MA006Accident · 217 fatalClass 1 · MajorFinal reportBoeing 767-366-ER · Atlantic Ocean (Atlantic Ocean)The National Transportation Safety Board determines that the probable cause of the EgyptAir flight 990 accident is the airplane's departure from normal cruise flight and subsequent impact with the Atlantic Ocean as a result of the relief first officer's…Oct 31, 1999 · SUGAP · Destroyed NTSB MIA99LA258Accident · 2 fatalLimited investigationFinal reportBeech BE-200 · Atlantic Ocean (Atlantic Ocean)undetermined.Sep 19, 1999 · YV385 · Destroyed NTSB SEA99LA122Accident · No injuriesLimited investigationFinal reportCessna 150M · Glenns Ferry, IDThe pilot's failure to maintain directional control during the attempted takeoff. A related factor was the pilot's lack of recent experience.Jul 17, 1999 · N704AX · Substantial damage NTSB ANC99LA065Accident · 1 fatalLimited investigationFinal reportStinson 108 · Anchorage, AKUndetermined.May 24, 1999 · N793C · Destroyed NTSB MIA99LA156Accident · 2 fatalLimited investigationFinal reportChampion Glastar · Mableton, GAAn in-flight loss of control for undetermined reasons, resulting in an in-flight collision with trees and the ground.May 19, 1999 · N75419 · Destroyed NTSB ANC99LA005Accident · 1 fatalLimited investigationFinal reportBeech G-35 · Neah Bay, WAUndetermined. Missing Aircraft.Oct 4, 1998 · N4479D · Destroyed NTSB ANC98LA001Accident · 1 fatalLimited investigationFinal reportPiper PA-22-160 · Sterling, AKUndetermined.Oct 3, 1997 · N8955D · Destroyed NTSB SEA97LA157Accident · No injuriesLimited investigationFinal reportCessna 172M · UTUndetermined.Jul 1, 1997 · N4395R · Substantial damage NTSB CHI97FAMS2Accident · 2 fatalMissing aircraftFinal reportBeech 95-C55 · Grand Haven, MIundetermined.Apr 21, 1997 · N242BS · Destroyed NTSB ANC97FA008Accident · 1 fatalField investigationFinal reportCessna 208B · Bethel, AKfailure of the pilot to maintain control of the airplane, while maneuvering to reverse direction after takeoff, after encountering an undetermined anomaly. The undetermined anomaly was a related factor.Nov 26, 1996 · N4704B · Destroyed NTSB MIA95LA166Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Orlando, FLUnknown.Jun 28, 1995 · N25AT · Substantial damage NTSB MIA95LA144Accident · 1 fatalLimited investigationFinal reportPiper PA-32-260 · Vieques, PRUndetermined.Jun 2, 1995 · N41528 · Substantial damage NTSB LAX95LA063Accident · 2 fatalLimited investigationFinal reportMcDonnell Douglas 500 · Chuuk Island (Pacific Ocean)undetermined.Dec 29, 1994 · N9128F · Destroyed NTSB ANC94LA133Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Fairbanks, AKUndetermined.Sep 10, 1994 · N68522 · Substantial damage NTSB ANC94LA127Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Eagle, AKUndetermined.Jul 30, 1994 · N3849M · Substantial damage NTSB CHI94FA330Accident · 1 fatalField investigationFinal reportBell 47G-5A · Wisconsin Rpds, WIUndetermined.Mar 22, 1994 · N2991W · Destroyed NTSB LAX94LA187Accident · 2 fatalLimited investigationFinal reportBell 206A · Pacific Ocean (Pacific Ocean)undetermined.Mar 1, 1994 · N4712R · Destroyed NTSB LAX94LA041Accident · 2 fatalLimited investigationFinal reportHughes 369D · Pacific Ocean (Pacific Ocean)An undetermined event that resulted in the accident.Nov 7, 1993 · N5172K · Destroyed NTSB FTW93TA#06Accident · No injuriesFinal reportCessna CE-550 · Comayagua, HondurasJun 17, 1993 · N2734K · Substantial damage NTSB FTW93TA#07Accident · No injuriesFinal reportPiper PA-18-150 · Del Rio, TXJun 12, 1993 · N83325 · Substantial damage NTSB FTW93TA#04Accident · No injuriesFinal reportPiper PA-18-150 · Godley, TXMay 16, 1993 · N2520S · Substantial damage NTSB FTW93TA#03Accident · No injuriesFinal reportBell 206B · Dallas, TXMar 16, 1993 · N3211N · Substantial damage NTSB DEN93LA014Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Boulder, COUndetermined.Dec 2, 1992 · N2751G · Substantial damage NTSB MIA92LA151Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics LA-4-200 · FLSubstantial damage to the airplane during Unknown phase of flight for undetermined reasons.Jul 9, 1992 · N2969P · Substantial damage NTSB ATL92GA121Accident · 2 fatalFinal reportEnstrom 280FX · Summerville, SCThe pilot's inadvertent flight into IMC, which resulted in an in flight collision with trees. Factors were the obscured sky and foggy weather conditions, and the night lighting conditions at the time of the accident.Jun 7, 1992 · N86262 · Destroyed NTSB DEN92LA043Accident · No injuriesLimited investigationFinal reportCessna 172Q · Englewood, COUndetermined.Mar 18, 1992 · N66076 · Substantial damage NTSB BFO92TA#01Accident · No injuriesFinal reportMcdonnell Douglas 369E · Clinton, MDFeb 12, 1992 · N1600Q · Substantial damage NTSB BFO92FA010Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Chesapeake Bay, MDUndetermined. The aircraft wreckage has not been located.Oct 5, 1991 · N55657 · Destroyed NTSB DEN91LA059Accident · No injuriesLimited investigationFinal reportBeech A36 · Salida, COThe dual student's poor takeoff technique, his failure to maintain directional control, and inadequate supervision by the PIC CFI. A factor was: the dual student's lack of experience in mountain flying.Apr 6, 1991 · N4595S · Substantial damage NTSB CHI90LA280Accident · 1 fatalLimited investigationFinal reportPiper PA-22-150 · Engadine, MIA collision with trees and the terrain for undetermined reasons.Dec 2, 1989 · N2440P · Substantial damage NTSB FTW90GA040Accident · Serious injuriesFinal reportAerospatiale AS-350B · Liberty Hill, TXUndetermined.Nov 30, 1989 · N5804T · Destroyed NTSB ANC89LA181Accident · 4 fatalLimited investigationFinal reportCessna R172K · Anchorage, AKUndetermined.Aug 12, 1989 · N1211V · Destroyed NTSB DEN88LA162Accident · No injuriesLimited investigationFinal reportCessna 177RG · Santa Teresa, NMAn unknown person or persons took a Cessna 177RG from a small airport near the mexican border, without permission. State police found it crashed in a field 2 miles southwest of Santa Teresa airport, and notified the owner. No witnesses have been found to…Jul 17, 1988 · N34338 · Substantial damage NTSB MIA87LA161Accident · 2 fatalLimited investigationFinal reportPiper PA-23-250 · Missing, FLThe acft failed to arrive at its destination on a flight from miami, FL to aruba, netherland antilles via andros is, great inagua & port au prince. According to a flt plan filed by the plt the acft carried enough fuel for 8 hours & 30 minutes of flt, along…May 14, 1987 · N640CC · Destroyed NTSB MKC87LA080Accident · No injuriesLimited investigationFinal reportFairchild SA-227 · Springfield, MOOn April 6, 1987 a crew operating a metro iii, commuter acft noticed damage on both eng nacelles during a preflt insp. The commuter operator chief pilot was notified and an on site insp was made. The crew originally rptng the damage claimed they were not at…Apr 7, 1987 · N26863 · Substantial damage NTSB MKC87LA046Accident · No injuriesLimited investigationFinal reportCessna 150M · Kansas City, MOThe student plt rptd colliding with a parked fuel truck during taxi on 1/24/87. Inspection of the acft revealed only minor leading edge skin damage to the rt wing. The acft was released for further trng flts. The acft operated for more than a wk with no one…Jan 24, 1987 · N671HA · Substantial damage NTSB LAX87LA058Accident · 2 fatalLimited investigationFinal reportCessna 182L · Oceano, CAWitnesses stated that while the acft was climbing after takeoff, it appeared to be lower than normal. One witness rprtd that the eng sounded as if it was running rough. Another witness stated that the acft had begun making a left turn when he saw flames…Nov 30, 1986 · N66CF · Destroyed