NTSB investigations, 1984
10 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\") = 1984
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") = 1984 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 MIA85LAMS1Accident · 1 fatalFinal reportAeronca 7ACAcft was reported overdue 3 days after it departed cross city, FL, on a VFR x-country. Search and rescue operations began on 12/26/84 and were suspended on 01/07/84. Plt and acft were not found.NTSB ATL85FAMS1Accident · 2 fatalMissing aircraftFinal reportGrumman American AA-5 · Dayton, OHAircraft missing on a flight from Dayton, OH to gallipolis, OH two persons on board.NTSB ANC84FAMS2Accident · 2 fatalMissing aircraftFinal reportPiper PA-12 · Anchorage, AKThe acft departed on 9-27-84 and was reported missing the following day. USAF rcc conducted 140 unsuccessful search missions. No wreckage was ever discovered. Both occupants are presumed to have been fatally injured.NTSB ANC84FAMS3Accident · 1 fatalMissing aircraftFinal reportCessna U206G · AKPlt received 2 wx briefings before the one hour fourty five minute flt. Plt was advised of adverse wx conditions in mountains with high winds and frequent low visibility. Icing conditions were also forecast btw 9,000 and 13,000 ft. the acft is still missing…NTSB ANC84LAMS1Accident · 5 fatalFinal reportCessna 401 · Anchorage, AKAt 0630 AKDT the plt obtained a wx briefing for the flt which forecast VFR with occasional marginal conditions along the route of flt. At 0704, the plt obtained an updated briefing at which time the destination of cantwell was reported IFR. At 0731 AKDT, the…NTSB NYC84FAMS1Accident · 2 fatalMissing aircraftFinal reportCessna 172N · Nantucket, MAThe acft disappeared after departing on the return leg of a x-country. The plt had called the operator at the home base and reported that IMC weather existed for the return. The plt was informed that the acft was not needed and he did not need to hurry back.…NTSB LAX84LAMS3Accident · 1 fatalFinal reportBellanca 17-31A · CABetween may 31 & June 1, 1984, the private plt is believed to have driven to the airport, parked his car, & boarded his aircraft for a presumed personal flt. The plt's wife became concerned about her husband's failure to appear at work, & she notified local…NTSB FTW84LAMS4Accident · 1 fatalFinal reportPiper PA-32-260 · Lafayette, LAThe acft has been missing since 5/10/84. The owner called for his acft preflighted and departed on a southerly heading. An off shore oil rig spotted a twin engine acft heading south. Search efforts by cap were unsuccessful. The plt gave no indication of his…NTSB MIA84FA126Accident · 6 fatalField investigationFinal reportCessna 402B · Missing Acft, MSThis Acft disappeared on a flt from ft lauderdale, FL to bimini, Bahamas. After departure, the Acft flt plan was activated by radio. This was the last communication with the Acft. An itap radar readout revealed an Acft flt that departed at the appropriate…NTSB MIA84LA114Accident · 4 fatalLimited investigationFinal reportPiper PA-28-235 · Sanibel Island, FLThe acft failed to arrive at its destination. A satellite photo of the area showed wx & cloud cover between the departure & destination arpts. Radar data showed that an acft had left key west, FL, at about 1700, went northbound at 4500 until it encounter bad…