NTSB investigations, MN
5 cases where the first occurrence was “Fire”.
Cases per year
| 1984 | 2 |
|---|---|
| 1989 | 1 |
| 1999 | 1 |
| 2002 | 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 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\" = 171)
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 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" = 171) 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 CHI02LA099Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · South St. Paul, MNA loss of engine power due to an electrical short of the P-lead, and loose fuel line connection as a result of improper maintenance.NTSB CHI99LA188Accident · No injuriesLimited investigationFinal reportCessna 172N · Cloquet, MNa fire which initiated from an undetermined origin.NTSB MKC89LA087Accident · No injuriesLimited investigationFinal reportCessna 180 · Marshall, MNThe failure of an unapproved weld between the exhaust system and muffler. The failed weld resulted in the muffler separating and an in-flight fire.NTSB CHI85LA001Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Greenbush, MNFollowing an uneventful approach and landing, the plt was taxiing back up the runway when the right engine quit. The right seat passenger immediately noted flames coming from the engine and notified the plt, who swung the acft into positon for wind to keep…NTSB CHI84IA196Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-10-40 · Minneapolis, MNDuring climb from FL330 to FL370 the 1st officer saw sparks and smoke coming from the left side panel under his glare shield. Cockpit lights were turned off and smoke stopped. Flt returned to Minneapolis and landed without incident. Inspection of the acft…