NTSB investigations, 2006
13 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\") = 2006
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") = 2006 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 DEN07IA037Incident · Minor injuriesIncident investigationFinal reportBoeing 737-824 · Colorado Spring, COA short circuit in the primary (non-rechargeable) battery, most likely due to it being recharged. This internal short led to thermal runaway, battery failure, and an explosion.NTSB LAX07CA028Accident · Minor injuriesData collectionFinal reportStrategie Ballloon Amazon · Page, AZThe pilot's failure to identify grass clippings in the balloon envelope during a preflight inspection, which resulted in the balloon catching fire in flight.NTSB ATL07CA015Accident · No injuriesData collectionFinal reportCessna 172G · Dalton, GAThe pilot's improper starting procedures, which resulted in an on-ground engine fire.NTSB DFW07IA018Incident · No injuriesIncident investigationFinal reportBell 206-L4 · Abbeville, LAA fire in the baggage area for undetermined reasons.NTSB DEN06CA124Accident · No injuriesData collectionFinal reportBell 47G-2 · Hayden, ALengine fire for reasons undetermined.NTSB MIA06IA133Incident · No injuriesIncident investigationFinal reportBoeing 737-400 · Miami, FLThe pilot's inadvertent application of the left brakes at touchdown. Contributing to the incident was insufficient information in the quick reference handbook on the loss of touchdown protection with an inoperative anti-skid system.NTSB LAX06LA271Accident · Minor injuriesLimited investigationFinal reportBoeing E75 · Morgan Hill, CAExcessive fuel flow through the carburetor which resulted in leaking fuel, and subsequent in-flight fire while maneuvering.NTSB LAX06FA238Accident · No injuriesField investigationFinal reportLearjet 55 · Van Nuys, CAAn in-flight fire of undetermined origins.NTSB CHI06CA155Accident · No injuriesData collectionFinal reportMcFarland Rotorway Exec · Mooresville, INAn in-flight fire for undetermined reasons.NTSB ATL06IA071Incident · No injuriesIncident investigationFinal reportBeech C90A · Raleigh, NCThe inadequate manufacturing process, which resulted in a windshield fire and subsequent emergency landing.NTSB DFW06LA104Accident · Minor injuriesLimited investigationFinal reportCessna 210F · Lubbock, TXAn in-flight electrical fire for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ATL06IA054Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Asheville, NCThe improper installation of the pilot's windshield by company maintenance personnel, which resulted in flame and smoke in the cockpit, and subsequent emergency landing.NTSB DCA06MA022Accident · Minor injuriesClass 1 · MajorFinal reportDouglas DC-8 · Philadelphia, PAan in-flight cargo fire that initiated from an unknown source, which was most likely located within cargo container 12, 13, or 14. Contributing to the loss of the aircraft were the inadequate certification test requirements for smoke and fire detection…