NTSB investigations, IL
11 cases where the first occurrence was “Gear collapsed”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 2 |
| 1985 | 1 |
| 1991 | 2 |
| 1998 | 2 |
| 2001 | 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\" = 190)
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" = 190) 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 CHI02LA018Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Peoria, ILThe gear collapse for undetermined reasons during the landing roll. A factor was the pilot not using a proper touchdown point by landing long.NTSB CHI01LA079Accident · No injuriesLimited investigationFinal reportCessna 310R · Cahokia, ILThe collapse of the left main landing gear during landing roll for undetermined reasons.NTSB CHI98LA295Accident · Minor injuriesLimited investigationFinal reportNorth American SNJ-6B · Quincy, ILthe right main landing gear collapsed for undetermined reasons.NTSB CHI98LA174Accident · No injuriesLimited investigationFinal reportCessna 310L · Wheeling, ILthe collapse of the left main landing gear for undetermined reasons.NTSB CHI91LA261Accident · No injuriesLimited investigationFinal reportPiper PA-32-R300 · Lake In Hills, ILThe pilot's failure to perform an adequate preflight by assuring the gear lever was in the down and locked position.NTSB CHI91LA201Accident · No injuriesLimited investigationFinal reportPiper PA-28-201R · Wheeling, ILThe pilot in command's inadequate pre-flight inspection. Factors contributing to this accident were the landing gear lever not being engaged, the use of an inadequate procedure by the pilot-in-command, and the inadvertent gear retraction during takeoff roll.NTSB CHI85LA105Accident · No injuriesLimited investigationFinal reportCessna 172RG · Lawrenceville, ILThe private plt & his instructor were practicing instrument approaches. The instructor stated that the fuel gages were reading low & the VOR needle was oscillating, so they decided to make a straight-in landing. He stated that they lowered the gear & flaps,…NTSB CHI84IA224Incident · Minor injuriesIncident investigationFinal reportBeech 99 · Chicago, ILLanding gear extended but not locked. Crew could not rectify situation by using normal and emergency gear extension procedures. Gear collapsed on touchdown. Investigation disclosed a fatigue crack in rt main gear hydraulic actuator allowing a loss of…NTSB CHI84FA076Accident · No injuriesField investigationFinal reportBeech BE-99 · Galesburg, ILThe main gear retracted while the acft was being taxied to the taxioff position. Investigation revealed that a landing gear maintenance valve PN22400-1, SN19 manufactured by airright inc had corroded and was allowing stray voltage to cyclethe landing gear…NTSB CHI83LA088Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · St. Jacob, ILThe pilot reported that during the landing roll, he inadvertently retracted the gear.NTSB CHI82DA166Accident · No injuriesFinal reportCessna 210 · Galesburg, ILThe pilot was discussing short field landing techniques and the use of flaps with the student pilot/passenger and forgot to lower the landing gear. The wheels up landing resulted in substantial damage to the aircraft.