NTSB investigations, 1986
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\") = 1986
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") = 1986 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 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 MIA87LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Lantana, FLThe pilot stated the aircraft performed sluggishly during takeoff and would not climb to clear trees at the departure end of the runway. The takeoff was aborted and the aircraft overran the runway encountering sand and nosing over. The pilot stated that…NTSB ANC87LA005Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC-12D · Chickaloon Flat, AKThe pilot-in-command refused to cooperate and would not submit an NTSB form 6120.1 nor would he discuss the accident except that he crashed upon landing. The plts med. Cert had expired.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 ANC86LA036Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kotzebue, AKThe student pilot lost control of the aircraft on landing at a winter ice landing strip.