NTSB investigations, IL
5 cases where the sequence of events included Cabin safety event.
Cases per year
| 2010 | 1 |
|---|---|
| 2014 | 1 |
| 2015 | 1 |
| 2018 | 1 |
| 2019 | 1 |
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '110' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '110' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 DCA20CA046Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 737 · Chicago, ILan abrupt stop during taxi to avoid a collision with another airplane, causing a flight attendant to fall.NTSB DCA19CA038Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 737 · Chicago, ILan object which fell from an overhead bin struck a flight attendant resulting in a serious injury.NTSB CEN15CA274Accident · No injuriesData collectionFinal reportEnstrom F 28C · Romeoville, ILThe certified flight instructor (CFI) did not maintain directional control during a downwind emergency running landing to soft muddy terrain, which resulted in a dynamic rollover. Contributing to the accident was the CFI's delayed or insufficient remedial…NTSB CEN14LA316Accident · 1 fatalLimited investigationFinal reportGrazhopper Trike · Ottawa, ILThe noncertificated pilot’s improper decision to operate the powered-parachute at low altitude through mist in a confined area while he was impaired by multiple sedating medications, which resulted in his loss of control of the parachute and subsequent impact…NTSB CEN10LA220Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas DC-9-82(MD-82) · Chicago, ILThe flight attendant's loss of balance resulting in a fall and a broken wrist.