NTSB investigations, 1987
3 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\") = 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\" = 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") = 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" = 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 MIA87LA161Accident · 2 fatalLimited investigationFinal reportPiper PA-23-250 · Missing, FLThe acft failed to arrive at its destination on a flight from miami, FL to aruba, netherland antilles via andros is, great inagua & port au prince. According to a flt plan filed by the plt the acft carried enough fuel for 8 hours & 30 minutes of flt, along…NTSB MKC87LA080Accident · No injuriesLimited investigationFinal reportFairchild SA-227 · Springfield, MOOn April 6, 1987 a crew operating a metro iii, commuter acft noticed damage on both eng nacelles during a preflt insp. The commuter operator chief pilot was notified and an on site insp was made. The crew originally rptng the damage claimed they were not at…NTSB MKC87LA046Accident · No injuriesLimited investigationFinal reportCessna 150M · Kansas City, MOThe student plt rptd colliding with a parked fuel truck during taxi on 1/24/87. Inspection of the acft revealed only minor leading edge skin damage to the rt wing. The acft was released for further trng flts. The acft operated for more than a wk with no one…