NTSB investigations, 1983
5 cases where the first occurrence was “Missing aircraft”.
Cases per year
| 1982 | 8 |
|---|---|
| 1983 | 5 |
| 1984 | 10 |
| 1985 | 12 |
| 1986 | 6 |
| 1987 | 4 |
| 1988 | 4 |
| 1989 | 4 |
| 1990 | 5 |
| 1991 | 3 |
| 1992 | 8 |
| 1993 | 7 |
| 1994 | 4 |
| 1995 | 3 |
| 1996 | 2 |
| 1997 | 5 |
| 1998 | 4 |
| 1999 | 3 |
| 2000 | 4 |
| 2001 | 2 |
| 2002 | 3 |
| 2003 | 4 |
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 1 |
| 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 year(c.\"eventDate\") = 1983
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\" = 420)
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") = 1983 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" = 420) 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 MIA84LA035Accident · 1 fatalLimited investigationFinal reportCessna 340A · Nr. Orangeville, FLThe acft disappeared fm radar coverage while in cruise flt at 10,000 feet MSL near Orangeville, FL. The ATC transcript revealed that the plt had been inquiring abt the weather ahead of him and was cleared to descend to 6000 in order to get below strong…NTSB ANC84FA013Accident · 4 fatalField investigationFinal reportCessna 206 · Kenai, AKThe acft departed nondalton, AK at aprx 1135 yst on a flt to Kenai, AK. At aprx 1215 yst, the plt report that he was over west forelands & requested the Kenai wx. About 4 min later, he requested a df steer to the Kenai arpt. A short time later, radio contact…NTSB FTW84LAMS1Accident · 1 fatalFinal reportPiper PA-34-200 · Gulf Of MexicoThe acft disappeared on a flt over a part of the Gulf Of Mexico south of corpus christi in an area of thunderstorm activity. The storms were densely packed and it was considered unlikely that VFR flt could be conducted in the area. Theaccident acft was in…NTSB MIA84LA007Accident · 3 fatalLimited investigationFinal reportCessna T-210-J · FLThis acft is missing on a flt from andros town, Bahamas to ft. pierce, FL. After departure the acft contacted nassau to file a VFR clearance and called miami fss to report 60 DME east of ft. lauderdale in heavy rain. The plt requested information on how to…NTSB LAX83LAMS4Accident · 1 fatalFinal reportCessna 152 · Missing AcftThe plt reportedly took off on a 1 hr local. The Acft did not return & was presumed to have crashed. Also, it was presumed to have been destroyed & the plt was presumed to have been fatally injured. The owner/operator provided info which suggested that the…