NTSB investigations, 1989
20 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\") = 1989
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") = 1989 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 LAX90FA061Accident · Minor injuriesField investigationFinal reportBoeing 737-204 · Tucson, AZFailure of the operator's maintenance personnel to detect an electrical wire which had chafed against a hydraulic line and which eventually arced causing a leak in the hydraulic line and subsequent fire and hydraulic system failure. In addition, previous wear…NTSB CHI90LA048Accident · No injuriesLimited investigationFinal reportCessna 310Q · Grand Rapids, MIThe undetermined engine compartment fire during the initial climbout. A factor was the failure of the pilot to shut off the fuel supply to the engine.NTSB CHI90FA029Accident · 3 fatalField investigationFinal reportPiper PA-28-235 · Monroe Center, ILIn-flight fire initiated by an inadequately installed wiring harness and propagated by an existing fuel leak which was not repaired.NTSB MKC90FA026Accident · Serious injuriesField investigationFinal reportCessna T210 · Columbia, MOAn engine compartment fire due to a missing turbocharger exhaust duct and tailpipe assembly. The clamp used to retain the tailpipe assembly to the turbocharger was also missing, contributing factor(s) was: the soft terrain.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 MKC90FA020Accident · 1 fatalField investigationFinal reportCessna 402B · Little Rock, ARA leak in the aircraft's fuel system which resulted in an in-flight fire. The origin of the fuel leak was not determined.NTSB MKC89LA187Accident · No injuriesLimited investigationFinal reportBeech V35B · Concord, ARImproper installation of the alternator wiring harness by the pilot/owner which resulted in chafed wiring and a subsequent electrical fire. The uneven terrain was a contributing factor.NTSB LAX89DVM05Accident · No injuriesFinal reportSkelton Emeraude · Watsonville, CAAn inadequate fuel line, due to improper installation by the owner/builder, fuel line failure, fuel line leak, and a subsequent fire.NTSB BFO89FA059Accident · 2 fatalField investigationFinal reportBeech E18S · Glen Burnie, MDA fire that erupted in the cockpit of the aircraft (under a side panel). Related factors were: smoke and fumes in the cockpit which reduced the pilot's visual perception and ability to see.NTSB MIA89LA200Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Luquillo, PRFailure of the left exhaust stack which resulted in an engine fire, loss of engine power, and subsequent ditching of the acft in ocean waters.NTSB CHI89FA122Accident · No injuriesField investigationFinal reportPiper PA-60-700P · Griffith, INFailure of the turbocharger exhaust tailpipe assembly retaining clamp.NTSB ATL89FA166Accident · 3 fatalField investigationFinal reportPiper PA-60-601P · Lithia Springs, GAInflight engine/wing fire due to a failure of the right engine's left exhaust tailpipe. The exhaust tailpipe failed in fatigue as a result of fluctuating stresses induced by a deteriorated engine mount in conjunction with unevenly distributed clamping loads…NTSB SEA89LA109Accident · No injuriesLimited investigationFinal reportCessna 177B · Minden, NVThe inadequate maintenance which caused a crack in the fuel pressure line leading into the carburetor.NTSB ATL89MA123Accident · 3 fatalMajor investigationFinal reportBeech 200 · Pensacola, FLAn in flight cabin fire of undetermined origin, and smoke (toxic condition) in the crew compartment, which resulted in physical impairment of the flight crew.NTSB MKC89LA087Accident · No injuriesLimited investigationFinal reportCessna 180 · Marshall, MNThe failure of an unapproved weld between the exhaust system and muffler. The failed weld resulted in the muffler separating and an in-flight fire.NTSB FTW89LA077Accident · No injuriesLimited investigationFinal reportGulfstream 680FLP · Lohn, TXArson undertaken to conceal illegal activity.NTSB DCA89MA034Accident · No injuriesMajor investigationFinal reportBoeing 737-300 · Oakland, CAIgnition of puddled fuel from a blocked combustor drain line, and a slow start during which fuel was misted and blown out the tail pipe. An existing tailwind at the gate allowed the fuel to wet the tail surfaces and be ignited during the APU start. The…NTSB MKC89LA075Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Wynne, ARAn engine fire during engine start for undetermined reasons.NTSB MKC89LA066Accident · No injuriesLimited investigationFinal reportCessna 182RG · Ft. Madison, IAAn electrical wiring short that caused an in flight fire.NTSB ATL89LA087Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Huntersville, NCFire resulting from an oil leak of undetermined origin in the area of the left engine.