NTSB investigations, 1982
8 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
Latest 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\") = 1982
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") = 1982 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 ATL83FA049Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Ocean City, MDThe pilot and passenger bodies were recovered from the atlantic Ocean near Ocean City, MD. Both persons had died of drowning without serious traumatic injuries. The aircraft was not recovered. Low ceilings and visibilities were reportedin the area throughout…NTSB MIA83LA025Accident · 3 fatalLimited investigationFinal reportBeech 65-B80 · Missing Acft, BahamasThe flt departed ft. lauderdale at 1626, & at 1654 in the vicinity of bimini was advised to contact nassau radio. The flt failed to contact nassau & there were no further communications with the flt. Search efforts produced negative results. IMC prevailed on…NTSB FTW83FAMS1Accident · 4 fatalMissing aircraftFinal reportPiper PA-34-220T · Durango, COThe aircraft originally departed helena, mt on a flight believed to be to taos, NM. A landing was made at ogden, ut where the plane was serviced with 47.5 gal of fuel. The last radio communication was at 1735 MST 11/2/82. At that time, the aircraft was…NTSB MIA83FA017Accident · 8 fatalField investigationFinal reportPiper PA-31 · Missing Acft (Atlantic Ocean)The flt departed anguilla at 0803 ast. At 0805 the plt radioed st. maarten & filed a VFR flt plan to st. thomas. The flt plan showed a direct route of flt at 4,500 ft MSL with a time enroute of 45 min. The flt failed to arrive at the destination. Search…NTSB MIA83LA009Accident · 2 fatalLimited investigationFinal reportBeech H35 · Missing Acft (Atlantic Ocean)Aircraft Missing on a flight from marsh harbour Bahamas to ft. pierce FL. Thunderstorms were along the proposed route. Last recorded position on radar data log was at 27-06-13 north and 79-27-58 west. No radio communications were reported with flight after…NTSB ANC82DAG59Accident · 3 fatalFinal reportCessna 180 · Missing Acft, AKAircraft disappeared on this flight of 9/7/82. No flight plan was filed but it is believed pilot was on round robin from lake hood to two lakes and return.NTSB NYC83FA083Accident · 1 fatalField investigationFinal reportGrumman AA-1 · Missing Acft, NYThe non-instrument rated pilot called ground control and requested a VFR departure. He was advised that the field was IFR and an IFR clearance was needed. The pilot filed an IFR flight plan and about 15 min later called for his clearance. He had trouble…NTSB MIA82DA157Accident · 4 fatalFinal reportPiper PA-28R-201T · West Of Cross C, FLAt about 1605 CDT, the pilot activated his VFR flight plan from nashville, TN to venice, FL. At 1813, the pilot contacted tallahasee fss and was briefed on the weather conditions to sarasota, FL. This was the last known radio communication with the aircraft.…