NTSB investigations, 1990
14 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\") = 1990
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") = 1990 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 FTW91LA020Accident · No injuriesLimited investigationFinal reportCessna 172N · Plano, TXThe pilot's failure to follow the approved start procedures which resulted in an induction fire and the destruction of the airplane.NTSB ATL91LA009Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Summerville, SCAn eroded exhaust stack which allowed hot gases to impinge upon the firewall, and ignite cabin insulation.NTSB NYC91LA009Accident · No injuriesLimited investigationFinal reportCessna 172N · Dayton, OHA carburetor fire due to an engine backfire. A factor relating to the accident was improper remedial action taken by the pilot to extinguish the engine fire.NTSB SEA91IA003Incident · No injuriesIncident investigationFinal reportCessna 551 · Elma, WAInadequate inspection of the electrical wire bundle assembly by maintenance personnel, and chafing/burning of the wire bundle.NTSB LAX91FA001Accident · 1 fatalField investigationFinal reportMooney M20K · Flagstaff, AZThe pilot's decision to operate the aircraft with a known discrepancy; inadequate maintenance procedures; and the pilot's inflight loss of control due to smoke and fumes in the cockpit.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 ATL90DKG05Accident · No injuriesFinal reportAyres Bull Thrush · Americus, GAFailure of the engine main oil line which allowed the engine oil to be ignited by the hot engine.NTSB LAX90FA248Accident · Minor injuriesField investigationFinal reportMcDonnell Douglas 369HS · Modesto, CAIn-flight engine fire of undetermined origin.NTSB MKC90LA110Accident · Serious injuriesLimited investigationFinal reportBeech S35 · Gardner, KSAn in-flight fire of undetermined origin.NTSB MIA90FA101Accident · 1 fatalField investigationFinal reportLockheed L-1049F · Levittown, PRFire of an undetermined origin that resulted in a loss of power in two engines during a three engine ferry flight. Factors related to the accident were: failure of the pilot to obtain the required authorization for the three engine ferry flight, and his…NTSB DEN90LA077Accident · No injuriesLimited investigationFinal reportCessna 182J · Delta, COA deteriorated fuel line.NTSB LAX90LA109Accident · 1 fatalLimited investigationFinal reportCameron O-105 · Phoenix, AZImproper modification of the balloon's fuel/heater system by the owner/operator and failure of the fuel line connection, which resulted in a fuel system leak and gondola (basket) fire.NTSB LAX90LA107Accident · No injuriesLimited investigationFinal reportBeech B-19 · Chiriaco Summit, CAA engine compartment fire of undetermined origin dduring engine start.NTSB CHI90IA064Incident · No injuriesIncident investigationFinal reportBoeing 747-151 · Detroit, MIA fire in the aft cargo compartment for undetermined reasons(s).