NTSB investigations, MO
7 cases where the first occurrence was “Fire”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1986 | 2 |
| 1989 | 1 |
| 1998 | 1 |
| 2007 | 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\" = 'MO' 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" = 'MO' 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 DCA07MA310Accident · No injuriesClass 1 · MajorFinal reportMcdonnell Douglas DC-9-82 (MD-82) · St. Louis, MOAmerican Airlines’ maintenance personnel’s use of an inappropriate manual engine start procedure, which led to the uncommanded opening of the left engine air turbine starter valve, and a subsequent left engine fire, which was prolonged by the flight crew’s…NTSB CHI98LA114Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Benton, MOan engine fire for undetermined reasons.NTSB MKC90FA026Accident · Serious injuriesField investigationFinal reportCessna T210 · Columbia, MOAn engine compartment fire due to a missing turbocharger exhaust duct and tailpipe assembly. The clamp used to retain the tailpipe assembly to the turbocharger was also missing, contributing factor(s) was: the soft terrain.NTSB MKC87LA011Accident · No injuriesLimited investigationFinal reportGrumman G164B · Memphis, MOThe aerial application acft was en route to seed a wheat field when smoke came into the cockpit. The plt made a precautionary landing on a blacktop road. The road was the best available, but was not adequate and acft flipped forward to the inverted position.…NTSB MKC86LA085Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Jackson, MOIn cruise flt the PIC smelled something burning and noticed black and white smoke pouring fm the eng cowling. This was followed by a partial loss of pwr. A precautionary landing was made in a field. The PIC noticed flames erupting fm the eng area after…NTSB MKC83IA116Incident · No injuriesIncident investigationFinal reportLockheed L-1011-385-1 · Kansas City, MODuring descent an electric wire bundle shorted behind the flight engineers panel, a fire erupted with smoke. The flight engineer used a portable fire extinguisher to put out the fire.NTSB MKC82IA169Incident · No injuriesIncident investigationFinal reportCessna 421C · St. Louis, MOPilot reported, the flight encountered icing conditions near St. Louis and the propeller de-ice system was activated. When de-ice system was turned on, flames shot out from the lower right corner of the pilot's instument panel where the de-ice ammeter is…