NTSB investigations, IL
3 cases where the first occurrence was “Nose gear collapsed”.
Cases per year
| 1985 | 1 |
|---|---|
| 1988 | 1 |
| 1993 | 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 192)
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" = 192) 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 CHI93IA110Incident · No injuriesIncident investigationFinal reportFokker 100 · Chicago, ILFailure of the company station manager to follow proper dispatch procedures, and ice accumulation on the nose gear locking mechanism. Factors related to the incident were: wet snow (slush) on the runway at the departure airport, and inadequate design which…NTSB CHI88LA196Accident · No injuriesLimited investigationFinal reportCessna 320E · Springfield, ILDrg a night arrival, the plt failed to get a down & locked indcn for the nose gear. He made svrl low passes over the rwy for observation. Tower & fire/rescue personnel rprtd the nose gear appeared to be extended, so the plt made a normal landing. As the nose…NTSB CHI85LA270Accident · No injuriesLimited investigationFinal reportCessna 310D · Carbondale, ILThe acft was landing at dest arpt after a two hr xcountry flt. At gear ext no green light. Pilot recycled gear but still no light. Emergency ext used and three green indicated. On ld roll nose gear collapsed. Uplock arm tube was broken on the nose gear.