NTSB investigations, 1987
4 cases where the first occurrence was “Altitude deviation,uncontrolled”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 5 |
| 1984 | 13 |
| 1985 | 10 |
| 1986 | 6 |
| 1987 | 4 |
| 1988 | 8 |
| 1989 | 7 |
| 1990 | 2 |
| 1991 | 5 |
| 1992 | 3 |
| 1993 | 2 |
| 1994 | 4 |
| 1996 | 2 |
| 1997 | 7 |
| 1998 | 5 |
| 1999 | 3 |
| 2000 | 1 |
| 2001 | 2 |
| 2003 | 1 |
| 2004 | 3 |
| 2006 | 1 |
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\") = 1987
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\" = 110)
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") = 1987 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" = 110) 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 DEN87FA234Accident · 2 fatalField investigationFinal reportPiper PA-12-150 · Anaconda, MTBoth plts were reportedly avid big horn sheep hunters. On the morning of the accident, the 2nd plt picked up topographical charts of the area where the acft crashed. It was an area where the Montana department of fish, wildlife, and parks (fwp) had recently…NTSB ANC87LA136Accident · No injuriesLimited investigationFinal reportPiper PA-18 · High Lake, AKThe pilot and his passenger were on a fishing/sight-seeing flight when they encountered winds estimated at 35 knots blowing over a mountain ridge. The pilot attempted to fly over the ridge but turned away after experiencing a strong down draft. A second…NTSB LAX87FA087Accident · 1 fatalField investigationFinal reportCessna 208 · Cima, CAWhile on a day/vfr flt from ontario, CA to las vegas, NV, the acft collided with mountainous terrain near the top of a 6500' peak. Radar data showed that aprx 20 min before the acdnt, the acft began a gradual dscnt from about 10,000'. No preimpact part…NTSB MIA87LA070Accident · No injuriesLimited investigationFinal reportSmith, Ted Aerostar Aerostar 601 · Pahokee, FLThe plt stated that he was conducting an over water apch to rwy 17 when he observed traffic preparing to land ahead of him. He slowed the acft for traffic separation, lowered the gear, & extended partial flaps. He then stated that he felt an abnormal loss of…