NTSB investigations, IA
7 cases where the first occurrence was “Fire”.
Cases per year
| 1986 | 1 |
|---|---|
| 1987 | 2 |
| 1988 | 1 |
| 1989 | 1 |
| 2000 | 1 |
| 2005 | 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\" = 'IA' 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" = 'IA' 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 CHI05CA209Accident · No injuriesData collectionFinal reportNational Ballooning 751-12 · Indianola, IAThe in-flight fire due to the loose fuel line connection as a result of the pilot's inadequate preflight. A factor was the power lines.NTSB CHI00LA278Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Des Moines, IAA hydraulic fluid leak which resulted in a landing gear brake fire.NTSB MKC89LA066Accident · No injuriesLimited investigationFinal reportCessna 182RG · Ft. Madison, IAAn electrical wiring short that caused an in flight fire.NTSB CHI88IA045Incident · No injuriesIncident investigationFinal reportAerospatiale ATR-42 · Waterloo, IANTSB MKC87LA183Accident · No injuriesLimited investigationFinal reportCessna 401 · Ames, IAThe unsked pax flt was climbing to cruise altitude having just deptd Ames, IA, when the PIC noticed a fire in the left eng. The PIC aborted the climb and returned to Ames. The left eng was secured before lndg which was uneventful. A post-fire insp of the eng…NTSB MKC87LA154Accident · No injuriesLimited investigationFinal reportPiper PA-32RT · Oelwein, IADuring a personal night x-c flt, the plt noticed a glowing condition in the engine compartment and also a loss of manifold pressure. The plt shut the fuel off, pulled the mixture to cutoff, and declared an emergency. The acft made an emergency landing in a…NTSB MKC86FA151Accident · 3 fatalField investigationFinal reportWhittman WD (Bigx) · Sheldahl, IAWitnesses state that they saw two airplanes, one silver and one red, climbing northbound to cruise altitude in loose formation when the red aircraft's engine backfired and the antique fabric-covered aircraft started burning. Flames five to eight feet in…