NTSB investigations, 1997
15 cases where the first occurrence was “Fire”.
Cases per year
| 1982 | 27 |
|---|---|
| 1983 | 25 |
| 1984 | 21 |
| 1985 | 30 |
| 1986 | 28 |
| 1987 | 28 |
| 1988 | 15 |
| 1989 | 20 |
| 1990 | 14 |
| 1991 | 16 |
| 1992 | 17 |
| 1993 | 14 |
| 1994 | 22 |
| 1995 | 20 |
| 1996 | 11 |
| 1997 | 15 |
| 1998 | 13 |
| 1999 | 9 |
| 2000 | 12 |
| 2001 | 17 |
| 2002 | 15 |
| 2003 | 7 |
| 2004 | 12 |
| 2005 | 12 |
| 2006 | 13 |
| 2007 | 17 |
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 year(c.\"eventDate\") = 1997
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 year(c."eventDate") = 1997 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 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 CHI98LA041Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Burlington, KSan undetermined event resulting in the door seal inflation pump catching fire, the pilot's failure to close the cockpit air vents allowing heat and flames from the airplane's nose section to melt electrical wiring behind the instrument panel, and the pilot…NTSB MIA98LA028Accident · No injuriesLimited investigationFinal reportCessna 182A · Parkton, NCimproper installation of an auto battery cable which led to an in-flight fire due to the chaffed cable.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 CHI97LA255Accident · No injuriesLimited investigationFinal reportTaylorcraft L2A · Shelbyville, INthe inadequate preflight by the pilot and the loose fuel line fitting.NTSB ANC97LA093Accident · No injuriesLimited investigationFinal reportDouglas DC-4 · Venetie, AKA fire associated with the number 2 engine for undetermined reasons.NTSB FTW97LA309Accident · No injuriesLimited investigationFinal reportBeech F33A · Monroe, LAan electrical short, which burned a hole in a fuel line, and subsequent fire from the burning fuel.NTSB FTW97IA222Incident · No injuriesIncident investigationFinal reportAerospatiale ATR-72-12 · Dallas, TXthe engine fire during descent resulting from a loose, leaking fuel transfer tube due to improper installation and alignment of the transfer tube's retaining clip. Contributing factors were the inadequate design of the clamp, the failure of the operator to…NTSB ATL97LA078Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Sparta, TNA fire in the left engine started by a leak in the fuel pump.NTSB MIA97LA159Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas DC-10-30 · San Juan, PRan on ground engine fire in the No. 3 (right) engine resulting from a failed heat exchanger, and subsequent fuel leak. A factor in this accident was the cabin crew's improper handling of the evacuation which resulted in serious injury to a passenger.NTSB FTW97IA160Incident · No injuriesIncident investigationFinal reportBoeing 737-300 · Colorado Spgs, COAn oil leak around the APU aft bearing seal which resulted in a fire in the APU exhaust.NTSB ANC97LA055Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Quinhagak, AKA disconnected exhaust manifold collector, improper maintenance of the airplane by company maintenance personnel, and the pilot's poor judgement in electing to initiate another flight after observing smoke in the cockpit.NTSB MIA97LA134Accident · No injuriesLimited investigationFinal reportNavion A · Quincy, FLchafing of an electrical cable that was routed through the firewall, which resulted in electrical arching and an in-flight fire.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 ATL97LA050Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Memphis, TNfailure of maintenance personnel to properly inspect (and repair) the brake assembly, which allowed a subsequent brake fluid leak and eventual fire.