NTSB investigations, VA
5 cases where the first occurrence was “Fire”.
Cases per year
| 1985 | 2 |
|---|---|
| 1989 | 1 |
| 1995 | 1 |
| 2000 | 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\" = 'VA' 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" = 'VA' 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 IAD01IA017Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-82 · Dulles, VAthe operator's inadequate maintenance procedure to disconnect the Omega navigational system, which resulted in coaxial cables being cut and not properly protected. A factor in the incident was the lightning strike.NTSB BFO96LA009Accident · No injuriesLimited investigationFinal reportAerostar Raven S49A · Ark, VAthe flight instructor's improper procedures while inflating the balloon using an external fuel source, and the fuel leak.NTSB BFO90LA009Accident · No injuriesLimited investigationFinal reportBeech C33 · Richmond, VACracked fuel flow indicator fuel line which allowed fuel to come in contact with electrical components of the instrument panel which resulted in a fire.NTSB BFO85IA065Incident · No injuriesIncident investigationFinal reportBoeing 727-225 · Richmond, VAThe flt was in cruise at FL 350 when the cabin crew reported a cabin fire in the vicinity of seat 28A. Shortly after, a lower aft body overheat warning was recvd. The flt diverted to Richmond, VA. During descent, the flt crew performed the appropriate…NTSB BFO85LA038Accident · Minor injuriesLimited investigationFinal reportPiper PA 22-150 · New London, VAWhile exiting the traffic pattern after tkof the plt smelled smoke and observed flames near the left rudder pedal. After failing to put the fire out with his shoes the plt returned to the arpt and subsequently lndd using side window to look out of due to…