NTSB investigations, 1997, MN
3 cases where the first occurrence was “In flight collision with object”.
Cases per year
| 1982 | 3 |
|---|---|
| 1983 | 10 |
| 1984 | 7 |
| 1985 | 7 |
| 1986 | 3 |
| 1987 | 2 |
| 1988 | 2 |
| 1989 | 3 |
| 1990 | 4 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 3 |
| 1994 | 4 |
| 1995 | 6 |
| 1996 | 2 |
| 1997 | 3 |
| 1998 | 7 |
| 1999 | 4 |
| 2000 | 2 |
| 2001 | 1 |
| 2002 | 4 |
| 2003 | 8 |
| 2004 | 3 |
| 2006 | 2 |
| 2007 | 1 |
Where
Latest 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\") = 1997
AND c.\"eventStateOrRegion\" = 'MN' 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") = 1997 AND c."eventStateOrRegion" = 'MN' 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 CHI98LA045Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Lakeville, MNgeese that were encounter on an ILS final approach. Darkness was a related factor.NTSB CHI97LA192Accident · No injuriesLimited investigationFinal reportCessna A188B · Mcgregor, MNthe pilot's improper planning/decision, his failure to abort the takeoff while sufficient runway was remaining, and/or his failure to jettison his load in order to achieve sufficient climb rate to clear trees. His lack of certification and training to perform…NTSB CHI97FA059Accident · Minor injuriesField investigationFinal reportCessna 401 · Crystal, MNfailure of the pilot-in-command to ensure adequate removal of airframe ice from the aircraft during preflight.