NTSB investigations, 1991
16 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
Latest 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\") = 1991
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") = 1991 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 FTW92IA009Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE 3100 · Dfw Int'L Arpt, TXThe partial disconnection of the electrical connector at the torque sensing unit.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 CHI91DCQ09Accident · No injuriesFinal reportHispano Aviacion HA200 · Liberal, KSA disconnected ignition harness resulting in an inflight fire during maneuvering flight.NTSB SEA91IA219Incident · Minor injuriesIncident investigationFinal reportBoeing 747-151 · Seattle, WAA fire in the number 4 engine, resulting from a fuel leak at the main fuel control unit, due to improper maintenance by unknown/undetermined person. The L5 emergency exit failed to operatee due to a broken plastic pulley guard in the slide release mechanism.NTSB ATL91FA155Accident · No injuriesField investigationFinal reportPiper PA-46-310P · Cartersville, GAThe mechanic's improper replacement of the fuel line b-nut, and the inadequate inspection of the repair work by the quality assurance inspector.NTSB DEN91LA101Accident · No injuriesLimited investigationFinal reportCessna 421B · Colorado Spring, COA fractured fuel line and an improperly performed annual inspection.NTSB FTW91DPG14Accident · No injuriesFinal reportGrumman G-164A · Swifton, ARPartial failure of the hopper, chemical fire, and the failure of the landing gear. A factor ws the loss of visual outside reference.NTSB LAX91LA293Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Shoshone, CAAn electrical short of the battery cable.NTSB SEA91LA123Accident · Serious injuriesLimited investigationFinal reportAeronca 7BCM · St. Xavier, MTThe pilot's improper use of the fuel system, and the overfilling of the fuel tank. Contributing to the accident was: aerobatics performed, the pilot's inattention and the design of the fuel system.NTSB LAX91LA235Accident · No injuriesLimited investigationFinal reportBeech B95-B55 · Glendale, AZThe pilot's failure to secure the fuel cap during his preflight inspection. As a result, fuel leaked out of the wing tank onto the wing and ignited during the engine start procedures.NTSB LAX91LA233Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Point Magu, CAA short circuit in the airplane's strobe light electrical system which ignited the plastic tubing of the pitot static system causing an inflight fire and subsequent forced landing.NTSB MIA91LA151Accident · Minor injuriesLimited investigationFinal reportBeech 80 · Fort Lauderdale, FLThe improper maintenance work by an unknown person who crossthreaded a fuel nozzle injector fitting which allowed fuel to leak on the exhaust system initiating a fire. No reason for the right engine not to develop full power was found.NTSB LAX91LA195Accident · Serious injuriesLimited investigationFinal reportCessna U206 · Tulare, CAAn in-flight fire in the cabin/crew compartment area of the aircraft, due to failure of a fuel line located in the left doorpost area.NTSB CHI91LA138Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Millard, NEImproper use of APU by unknown personnel which resulted in the airplane's electrical wiring melting and subsequent short.NTSB LAX91LA102Accident · No injuriesLimited investigationFinal reportCurtiss-Wright E-4000 · Watsonville, CAThe inadequate design and length of the tailwheel assembly cable.NTSB ATL91LA045Accident · No injuriesLimited investigationFinal reportCessna 182A · Warm Springs, GAAn electrical short related to the alternator from an undetermined source.