NTSB investigations, 1985
5 cases where the first occurrence was “Undetermined”.
Cases per year
| 1982 | 4 |
|---|---|
| 1983 | 1 |
| 1984 | 6 |
| 1985 | 5 |
| 1986 | 5 |
| 1987 | 3 |
| 1988 | 1 |
| 1989 | 3 |
| 1991 | 2 |
| 1992 | 5 |
| 1993 | 5 |
| 1994 | 5 |
| 1995 | 2 |
| 1996 | 1 |
| 1997 | 3 |
| 1998 | 1 |
| 1999 | 5 |
| 2000 | 1 |
| 2001 | 3 |
| 2002 | 1 |
| 2004 | 1 |
| 2005 | 5 |
| 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\") = 1985
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 year(c."eventDate") = 1985 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 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 SEA85LYE01Accident · No injuriesFinal reportLuscombe 8A · Cheney, WAAcft was found abandoned after sustaining substantial damage in apparent lndg attempt in snow-covered marsh. Presumed pilot had expired student certificate and had registered acft to self under an alias. Circumstances of mishap unknown.