Fatal NTSB investigations
42 cases where the first occurrence was “Undetermined”.
Cases per year
| 1982 | 4 |
|---|---|
| 1984 | 5 |
| 1985 | 4 |
| 1986 | 2 |
| 1987 | 1 |
| 1989 | 2 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 3 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 2 |
| 1998 | 1 |
| 1999 | 4 |
| 2000 | 1 |
| 2001 | 2 |
| 2002 | 1 |
| 2004 | 1 |
| 2005 | 2 |
| 2007 | 2 |
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 c.\"highestInjuryLevel\" = 'Fatal'
AND 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."highestInjuryLevel" = 'Fatal' AND 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.NTSB CHI07FA279Accident · 2 fatalField investigationFinal reportSocata TB-20 Trinidad · Pointe Aux Pins, MIUndetermined.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.NTSB DFW05LA069Accident · 1 fatalLimited investigationFinal reportNolen Lite Squared · Holdenville, OKUndeterminedNTSB FTW04FA186Accident · 1 fatalField investigationFinal reportBell 206 L-1 · Cameron, LAThe helicopter's in-flight collision with water for undetermined reasons.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…NTSB SEA02LA037Accident · 2 fatalLimited investigationFinal reportMooney M20C · Netarts, ORReason for occurrence undetermined.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…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.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…NTSB MIA99LA258Accident · 2 fatalLimited investigationFinal reportBeech BE-200 · Atlantic Ocean (Atlantic Ocean)undetermined.NTSB ANC99LA065Accident · 1 fatalLimited investigationFinal reportStinson 108 · Anchorage, AKUndetermined.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.NTSB ANC99LA005Accident · 1 fatalLimited investigationFinal reportBeech G-35 · Neah Bay, WAUndetermined. Missing Aircraft.NTSB ANC98LA001Accident · 1 fatalLimited investigationFinal reportPiper PA-22-160 · Sterling, AKUndetermined.NTSB CHI97FAMS2Accident · 2 fatalMissing aircraftFinal reportBeech 95-C55 · Grand Haven, MIundetermined.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.NTSB MIA95LA144Accident · 1 fatalLimited investigationFinal reportPiper PA-32-260 · Vieques, PRUndetermined.NTSB LAX95LA063Accident · 2 fatalLimited investigationFinal reportMcDonnell Douglas 500 · Chuuk Island (Pacific Ocean)undetermined.NTSB CHI94FA330Accident · 1 fatalField investigationFinal reportBell 47G-5A · Wisconsin Rpds, WIUndetermined.NTSB LAX94LA187Accident · 2 fatalLimited investigationFinal reportBell 206A · Pacific Ocean (Pacific Ocean)undetermined.NTSB LAX94LA041Accident · 2 fatalLimited investigationFinal reportHughes 369D · Pacific Ocean (Pacific Ocean)An undetermined event that resulted in the accident.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.NTSB BFO92FA010Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Chesapeake Bay, MDUndetermined. The aircraft wreckage has not been located.NTSB CHI90LA280Accident · 1 fatalLimited investigationFinal reportPiper PA-22-150 · Engadine, MIA collision with trees and the terrain for undetermined reasons.NTSB ANC89LA181Accident · 4 fatalLimited investigationFinal reportCessna R172K · Anchorage, AKUndetermined.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…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…NTSB FTW86FA107Accident · 2 fatalField investigationFinal reportPiper PA-31-350 · Huffman, TXThe pilot was being vectored around thunderstorms in the area just prior to the accident. During the last radio contact the pilot was issued a vector to the destination airport. During this turn, for unknown reasons, the pilot lost control of the aircraft and…NTSB CHI86FA033Accident · 3 fatalField investigationFinal reportPiper PA-28-161 · Duluth, MNThe pilot departed crystal lake for a flight to visit relatives for thanksgiving. He did not obtain a preflight weather briefing nor did he contact any ground facility during the flight. He was qualified to fly in VFR conditions only. The aircraft impacted…NTSB DEN86FTE02Accident · 1 fatalFinal reportBeech 58 · Elbert, COThe acft crashed in a open field & was not found for 4 days. The home built acft, maintained largely by the plt, had the engine destroyed so completely that no determination could be made as to power being developed at impact. The plt reportedly had been…NTSB CHI85FA351Accident · 1 fatalField investigationFinal reportCessna 404 · South Lyon, MIThe acft took off and climbed to 5000 ft uneventfully. It then dropped off radar and subsequently impacted the ground in a flat upright attitude. A post-crash fire consumed the majority of the airframe. Eng and prop teardowns indicated no abnormalities and…NTSB NYC85FA189Accident · 2 fatalField investigationFinal reportSmith, Ted Aerostar Aerostar 601 · Erie, PADuring a normal IFR cruise flight, the pilot of air Ohio flight 21, did not respond to ATC instructions. Air Ohio flight 21 continued for 40 minutes with no reply and without deviation in altitude or heading until the discrete target disappeared from radar…NTSB FTW84LAMS5Accident · 1 fatalFinal reportCessna 152 · Missing AcftN93480 departed lafayette, la on a reported 2 hr sight-seeing flt over the gulf of Mexico & failed to return. There was no further contact with the plt & neither the plt nor the Acft have been found. The plt left a note suggesting possible suicide. Info…NTSB CHI84FA255Accident · 1 fatalField investigationFinal reportRobert B. Boston Glasair RG · Columbus, OHThe plt was on the 2nd leg of a flt to ferry the home-built acft to the lancaster arpt for further testing. After takeoff, he requested clearance to stay in the area for a few minutes. ATC asked him if he had a problem & the plt responded 'no, I just want to…NTSB FTW84FA237Accident · 1 fatalField investigationFinal reportBeech G35 · Tulsa, OKA witness stated it appeared as though the plt was attempting to perform a precautionary landing on a highway. As the acft reached the highway, the witness heard the engine accelerate to 'full power' and saw the acft pull up. The acft contacted the top static…NTSB MIA84LA128Accident · 4 fatalLimited investigationFinal reportCessna 172 · Marathon, FLThe acft was missing after departing on a flt from maraton, FL to everglades city, FL. Sar personnel found the bodies of the plt & 3 pax, but the acft was not found. It was presumed to have been destroyed during a crash in the gulf of Mexico.NTSB MIA84LA089Accident · 2 fatalLimited investigationFinal reportCessna P-210N · Key West, FLDuring his wx briefing the plt was given the flight precautions & enroute forecast along his proposed route of flt. Enroute at 14,000 ft the plt advised ARTCC that the flt had encountered rime ice. The controller cleared the flt to descend to 12,000 ft & the…NTSB ATL83LA078Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Daufuskie Islan, SCThe pilot's wife stated her husband had departed tampa, FL and could not recall if he had indicated a destination. She further stated her husband had a "charter". Investigation by law enforcement and drug enforcement personnel located cocaine in the aircraft…NTSB LAX82DAMS1Accident · 2 fatalFinal reportWing D-1 · Catalina Island, CAThe flt departed torrance at 1259 PDT & VFR conditions existed at the time. When the flt did not return a search was initiated. The search was terminated after 4 days. Friends & relatives speculated this may have been a dual instruction flt in preparation for…NTSB FTW82FRA21Accident · 1 fatalFinal reportPiper PA-32 · Houston, TXThe acft was found in a rice field on 6/5/82. Narcotics were found in the acft along with a large quantity of money on the pilot's body. The acft had N38312 painted on the side. The acft was stolen in atlanta, ga in October of 1981.NTSB ANC82FAG14Accident · 3 fatalFinal reportCessna 180 · Skwenta, AKThe aircraft departed finger lake at approximately 1000 ast for a short ice fishing trip to fish lakes. The aircraft never returned and a search was started. The wreckage was located near the kahiltna river about 5 miles from the intended destination on…