NTSB investigations, 1988, ND
2 cases where the first occurrence was “In flight collision with object”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 3 |
| 1984 | 2 |
| 1985 | 2 |
| 1986 | 3 |
| 1987 | 5 |
| 1988 | 2 |
| 1989 | 1 |
| 1990 | 2 |
| 1993 | 2 |
| 1994 | 2 |
| 1995 | 1 |
| 1996 | 3 |
| 1997 | 2 |
| 1998 | 3 |
| 2000 | 1 |
| 2001 | 2 |
| 2003 | 2 |
| 2004 | 2 |
| 2005 | 2 |
| 2006 | 2 |
| 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\") = 1988
AND c.\"eventStateOrRegion\" = 'ND' AND c.\"eventCountry\" = 'USA'
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\" = 220)
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") = 1988 AND c."eventStateOrRegion" = 'ND' AND c."eventCountry" = 'USA' 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" = 220) 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 DEN88LA161Accident · No injuriesLimited investigationFinal reportPiper PA-36-285 · Buchanan, NDThe plt said he made several swath runs passing under a transmission line and over a power line that crossed the end of the fld being sprayed. He said as he passed under the transmission line during a run the vert stab collided with the line and was damaged.…NTSB DEN88LA131Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Ayr, ND