NTSB investigations, IL
13 cases where the first occurrence was “Fire”.
Cases per year
| 1982 | 2 |
|---|---|
| 1989 | 1 |
| 1993 | 1 |
| 1994 | 2 |
| 1998 | 1 |
| 1999 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2005 | 2 |
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 c.\"eventStateOrRegion\" = 'IL' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'IL' AND c."eventCountry" = 'USA' 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 CHI06CA025Accident · Minor injuriesData collectionFinal reportPiper PA22-150 · Canton, ILThe fire for undetermined reasons.NTSB CHI05LA173Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Crete, ILThe separation of the drive belt, during cruise, leading to the puncturing of the oil cooler and subsequent fire. An additional cause was the pilot's restricted lookout during the emergency landing resulting in the hard landing.NTSB CHI04LA050Accident · No injuriesLimited investigationFinal reportCessna 182A · West Chicago, ILThe inadequate starting and flooded engine procedure used by certified flight instructor while providing instruction to the dual student.NTSB CHI02LA213Accident · No injuriesLimited investigationFinal reportWeatherly 201C · Malta, ILThe inflight fire and loss of engine power due to undetermined reasons. Factors associated with the accident were the lack of suitable terrain on which to land and the corn crop which was contacted during the landing.NTSB CHI01LA284Accident · Minor injuriesLimited investigationFinal reportCameron Balloons Shuttle 90 · Centralia, ILThe balloon envelope fire. A contributing factor was the flammability of the envelope.NTSB CHI99LA139Accident · No injuriesLimited investigationFinal reportCessna 182C · Loraine, ILA fuel system related fire in the engine compartment.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 CHI95IA028Incident · No injuriesIncident investigationFinal reportBoeing 747-251B · Chicag0, ILinattentive maintenance service of the airplane by the mechanic who failed to disengage the constant speed drive (CSD) after the engine runup had been completed. A factor in this incident was the lead mechanic not performing maintenance record keeping after…NTSB CHI94IA134Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE-146-200 · Chicago, ILa loose fuel nozzle.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 CHI90FA029Accident · 3 fatalField investigationFinal reportPiper PA-28-235 · Monroe Center, ILIn-flight fire initiated by an inadequately installed wiring harness and propagated by an existing fuel leak which was not repaired.NTSB CHI82FA312Accident · 2 fatalField investigationFinal reportTaylorcraft BL-65 · Rock Falls, ILAircraft caught fire while performing aerobatics and crashed out of control. Gas tank cap had come off and during inverted flight fuel spilled out and ignited.NTSB CHI82FEE12Accident · No injuriesFinal reportCessna 172RG · Wheeling, ILThe pilot stated that after the aircraft was started and warmed up approximately five to ten minutes the engine was shut down to investigate frozen brake pads. After the brake pads were freed the engine was restarted and during cranking the pilot noticed…