NTSB investigations, MA
4 cases where the first occurrence was “Fire”.
Cases per year
| 1985 | 1 |
|---|---|
| 1988 | 1 |
| 1991 | 1 |
| 2004 | 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\" = 'MA' 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" = 'MA' 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 IAD05LA005Accident · No injuriesLimited investigationFinal reportBeech C24R · Hyannis, MAThe mechanic's failure to secure the fuel pressure line to the fuel pressure gauge fitting, which resulted in an engine compartment fire and a subsequent loss of engine power.NTSB NYC91LA247Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas MD-82 · East Boston, MAThe malfunction of an electrical component in the cockpit, which resulted in smoke and the subsequent emergency evacuation of the passengers from the airplane.NTSB DCA88IA044Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-40 · Boston, MAThe improper installation of the battery ground connection that resulted in premature loosening of the connection and electrical arc ignition of pooled fuel in the cac bilge. The fuel was not drained overboard due to inoperative cac bilge area drain valves.…NTSB NYC85LA199Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-151 · Lawrence, MAAfter refueling the acft, the plt attempted to start the eng with the throttle full open and the mixture at idle cut off. The instructor thought the eng was vapor locked and was going to drain the gascolator when he noticed a fire in the carburetor airbox.…