NTSB investigations, 1998
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\") = 1998
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") = 1998 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 LAX99LA063Accident · Serious injuriesLimited investigationFinal reportRichard Young Harmon Rocket II · Esparto, CAThe owner's inadequate condition (annual) inspection, which failed to detect a loose fuel pump output line attachment fitting, which resulted in an in-flight fire. A factor in the hard landing and ground loop was the pilot's inability to see through the smoke…NTSB FTW99LA054Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-88 · Dfw Airport, TXA passenger sustained a hairline fracture during an emergency evacuation of the airplane.NTSB MIA99FA038Accident · No injuriesField investigationFinal reportBoeing 747-259B · Miami, FLa fire that started under the fuel truck's cab from an undetermined fuel leak, resulting in fire damage to the airplane.NTSB ATL99FA016Accident · 1 fatalField investigationFinal reportCessna 152 · Daytona Beach, FLAn interior cabin fire of undetermined origin. A factor was the power lines impacted during the emergency descent.NTSB MIA99LA013Accident · No injuriesLimited investigationFinal reportCessna 172N · Lawrenceville, GAA fire from an undetermined origin.NTSB MIA98LA228Accident · No injuriesLimited investigationFinal reportAir Tractor AT401 · Ruleville, MSA fire of undetermined origin.NTSB CHI98LA266Accident · No injuriesLimited investigationFinal reportCessna R182 · Bismarck, NDThe fatigue failure of the fuel system line fitting.NTSB NYC98LA114Accident · Serious injuriesLimited investigationFinal reportAerostar S81A · Strasburg, PAA fire of undetermined origin.NTSB CHI98LA127Accident · Serious injuriesLimited investigationFinal reportBoeing 727-227 · Chicago, ILthe passenger initiated evacuation of the airplane. A factor was the auxiliary power unit fire.NTSB FTW98LA182Accident · No injuriesLimited investigationFinal reportFroberg Rotorway Executive · Sand Springs, OKThe failure of the owner/pilot to complete maintenance on the helicopter.NTSB CHI98LA114Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Benton, MOan engine fire for undetermined reasons.NTSB FTW98FA156Accident · 2 fatalField investigationFinal reportBell 206-A · Rio Hondo, TXThe engine compartment fire due to undetermined reasons, which resulted in the in-flight separation of the tailboom.NTSB FTW98LA131Accident · Minor injuriesLimited investigationFinal reportCessna 210M · Lafayette, LAThe unsecured squat switch wires located in the nose gear that were crimped (damaged) when the landing gear was retracted and shorted, resulting in an in-flight fire. A factor was the failure of the landing gear to extend during the emergency descent/landing.