NTSB investigations, SC
11 cases where the first occurrence was “Fire”.
Cases per year
| 1984 | 1 |
|---|---|
| 1985 | 1 |
| 1986 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 1997 | 1 |
| 1999 | 2 |
| 2000 | 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\" = 'SC' 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" = 'SC' 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 ATL03LA016Accident · 1 fatalLimited investigationFinal reportChance Vought F4U-4 · Columbia, SCAn in-flight engine fire for undetermined reasonsNTSB MIA00LA079Accident · No injuriesLimited investigationFinal reportBeech D50E · Myrtle Beach, SCThe on-ground fire caused by fuel flowing out the fuel vent and near the exhaust of the left engine resulting in the on-ground fire and substantial damage to the airplane. A finding in the investigation was that all four fuel tanks had been filled before the…NTSB MIA00LA018Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Newberry, SCa fire in the cockpit caused by the exhaust muffler, which resulted in a forced landing in a field, and subsequent impact with a berm.NTSB ATL99LA047Accident · No injuriesLimited investigationFinal reportBalloon Works AX-8 · Beech Island, SCThe pilot's failure to follow the balloon checklist that resulted in a ground fire that destroyed the balloon envelope.NTSB ATL98LA012Accident · No injuriesLimited investigationFinal reportRoebuck Rans S-10 Sakota · Columbia, SCthe airplane builder's improper routing of vinyl/plastic cooling/vent line(s) for the engine oil system, and improper materials supplied by the manufacturer, which led to overheating of the line(s) in the engine compartment and an in-flight fire.NTSB ATL94FA093Accident · 1 fatalField investigationFinal reportNord 1101 · Spartanburg, SCThe pilot's failure to maintain adequate airspeed while maneuvering for an emergency landing. A factor in the accident was an inflight fire from an undetermined source.NTSB ATL92LA089Accident · No injuriesLimited investigationFinal reportBeech 23A-19 · Orangeburg, SCThe deterioration of the exhaust muffler which resulted in an inflight fire.NTSB ATL91LA009Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Summerville, SCAn eroded exhaust stack which allowed hot gases to impinge upon the firewall, and ignite cabin insulation.NTSB ATL86LA169Accident · No injuriesLimited investigationFinal reportCessna 172 · Pelion, SCThe private plt and student plt returned to the acft after pausing from landing practice for a soft drink. An engine start was attempted and a back fire occurred that started and induction fire. The intensity of the fire grew and the occupant exited the acft…NTSB ATL85LA227Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Camden, SCWhile the acft was flying over wooded terrain, the eng lost power. The plt saw a plowed field aprx 3 mi away & began an emerg apch to the field. The acft struck the tops of trees on final apch, but continued flying until the plt made a gear up landing. An…NTSB ATL84LA238Accident · Minor injuriesLimited investigationFinal reportCessna A188 · Hartsfield, SCThe plt said he smelled an electrical fire while spraying. He elected to land but before he could the engine quit. A forced landing was made in a cornfield. The acft burned. The fire origin was not located in the totally burned wreckage.