NTSB investigations, NY
8 cases where the first occurrence was “Fire”.
Cases per year
| 1987 | 1 |
|---|---|
| 1990 | 1 |
| 1996 | 1 |
| 1997 | 2 |
| 2002 | 1 |
| 2003 | 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\" = 'NY' 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" = 'NY' 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 NYC07IA063Incident · No injuriesIncident investigationFinal reportAirbus A-320-232 · New York, NYThe in-flight fire which was caused by the catastrophic failure of a 9-volt battery from an unknown cause.NTSB NYC04LA047Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Buffalo, NYThe pilot's improper procedure with regard to the cabin heater, which resulted in the over temperature of the heater and subsequent fire.NTSB NYC02FA160Accident · Serious injuriesField investigationFinal reportBoeing 747-256 · Jamaica, NYAn accessory gearbox fire of the number 2 engine, due to hot air bypassing a damaged compressor air seal stack, which resulted in an emergency evacuation.NTSB NYC97LA190Accident · No injuriesLimited investigationFinal reportBeech 58TC · E. Farmingdale, NYthe pilot's improper starting procedure, which led to an engine fire; and his failure to follow the emergency checklist, which contributed to the level of damage that the airplane received.NTSB NYC97LA068Accident · No injuriesLimited investigationFinal reportCessna 650 · Buffalo, NYA combination hydraulic fluid and fuel-fed fire which originated from electrical arcing, due to the lack of an adequate production standard from Cessna for the separation of flammable fluid lines and electrical lines. A factor was the lack of oversight from…NTSB DCA96MA079Accident · Minor injuriesClass 1 · MajorFinal reportMcDonnell Douglas DC-10-10CF · Newburgh, NYan in-flight cargo fire of undetermined origin. (NTSB Report AAR-98/03)NTSB NYC90IA219Incident · Minor injuriesIncident investigationFinal reportBoeing 727-231 · New York City, NYThe exhaust pipe fire in the APU which resulted in an unauthorized evacuation of the airplane by the passengers.NTSB NYC88FA051Accident · 1 fatalField investigationFinal reportCessna 310R · Hector, NYThe pilot made a routine IFR position report 12 minutes prior to the accident. Witnesses observed an 'orange ball' before the crash. Evidence at the crash site showed inflight jettison of the pilot's emergency window, positive aerodydnamic overload separation…