NTSB investigations, 1993
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\") = 1993
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") = 1993 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 NYC94LA041Accident · No injuriesLimited investigationFinal reportCessna 172N · Bar Harbor, MEA disconnected fuel line with the carburetor not installed, and improper dispatch of the aircraft.NTSB FTW93LA266Accident · No injuriesLimited investigationFinal reportBeech A36 · Houston, TXThe fuel leak which resulted from the mechanic's improper installation of the fuel line. A factor was the lead mechanic's inadequate post run up inspection.NTSB ANC93IA183Incident · No injuriesIncident investigationFinal reportCessna 180C · Anchorage, AKA frayed fuel hose.NTSB BFO93LA151Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Williamson, WVA fire in the cockpit area for undetermined reasons.NTSB LAX93LA325Accident · No injuriesLimited investigationFinal reportGlassair SH-2R · Bakersfield, CAThe improper maintenance by the pilot the night before the accident which resulted in an oil line leak near the airplane's exhaust system.NTSB BFO93LA118Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 8B · Flemington, NJThe passenger's inadvertent activation of the burner after the landing, causing the terrain to burn and subsequently igniting the Balloon envelope.NTSB ANC93IA115Incident · No injuriesIncident investigationFinal reportCessna 207 · Nome, AKThe chafed fuel line and chafed electrical wire and the improper maintenance procedure used to secure the electrical wire with a tie wrap.NTSB MIA93LA148Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Tampa, FLthe improper welding/repair by maintenence personnel of the exhaust system, which eventually failed allowing hot exhaust gasses and flame to burn a fuel line and start a fire.NTSB LAX93GA270Accident · Minor injuriesFinal reportBell 206L-3 · Agoura Hills, CAThe improper configuration of the aerial ignition device by the crew chief and an inadvertent activation of the unit by the pilot. The improper installation and configuration of the unit by maintenance personnel, inadequate crew coordination, and insufficient…NTSB ATL93IA113Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-82 · Savannah, GALeakage of the number 7 fuel nozzle, which resulted in an in flight engine fire.NTSB DEN93FA066Accident · Minor injuriesField investigationFinal reportCessna 310J · Broomfield, COFriction of escaping oxygen under high pressure igniting a lubricant in the nosewheel well area, and improper aircraft servicing by maintenance personnel.NTSB CHI93IA124Incident · No injuriesIncident investigationFinal reportAerospatiale ATR-42-300 · Moline, ILThe passenger's failure to extinguish a cigarette before placing it into the lavatory waste bin. Factors related to the incident were: an inoperative smoke detector in the lavatory, the manufacturer's inadequate maintenance program, and inadequate review of…NTSB LAX93LA159Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Fresno, CAthe improper installation of an electrical wire bundle, and, the chaffing and subsequent arcing of the wires against a fuel line which resulted in a fire.NTSB NYC93LA060Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Danbury, CTThe pilot's improper emergency procedures for an engine fire during starting which resulted in the substantial damage. Factors related to the accident were the pilot's improper starting procedure and his lack of total experience.