NTSB investigations, IL
11 cases where the first occurrence was “Main gear collapsed”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1986 | 3 |
| 1989 | 2 |
| 1998 | 1 |
| 2005 | 1 |
| 2006 | 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\" = 191)
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" = 191) 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 CHI07CA028Accident · No injuriesData collectionFinal reportCessna 421C · Moline, ILThe incorrect installation of the torque link scissor assembly by maintenance personnel, which resulted in the collapse of the right main landing gear during landing.NTSB CHI05LA136Accident · No injuriesLimited investigationFinal reportCessna 182TR · Wheeling, ILThe pilot failed to verify that the landing gear were fully extended and failed to perform the emergency landing gear extention procedures. Factors to the accident included the low hydraulic fluid level, and the weak battery that resulted in a partial…NTSB CHI98LA282Accident · No injuriesLimited investigationFinal reportCessna 310R · Cahokia, ILThe collapse of the left main landing gear during landing roll for undetermined reasons.NTSB CHI89IA084Incident · No injuriesIncident investigationFinal reportFokker F-27 MK500 · Moline, ILMaterial failure of the landing gear retraction and extension assembly. Inadequate maintenance and troubleshooting procedures in company directives were factors in this incident.NTSB CHI89FA058Accident · No injuriesField investigationFinal reportCessna 177RG · Rockford, ILThe inadequate servicing of the hydraulic fluid by maintenance personnel and the pilot's failure to extend the landing gear manually.NTSB CHI86LA201Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Wheeling, ILPlt reported that upon landing, gear was down and locked and after landing right wheel buckled. Investigation revealed break resulted from hard side load.NTSB CHI86LA175Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Chicago, ILThe pilot was unable to get a down and locked indication for the left main gear and upon touchdown the left gear collapsed. Inspection revealed an internal failure of the left main actuator. The fluid had leaked past the o-rings and prevented the gear from…NTSB CHI86FA119Accident · Minor injuriesField investigationFinal reportBoeing 737-222 · Chicago, ILThe left main landing gear collapsed moments after touchdown. Winds as reported by the twr were from 350 degs at 19 KTS gusting to 29 KTS. The captain and copilot reported the touchdown was normal. The 3 flight attendants said the aircraft landed hard and…NTSB CHI84LA130Accident · No injuriesLimited investigationFinal reportCessna 401 · Chicago, ILThe acfts left main gear collapsed during the landing roll. Investigation revealed that the bolt on the top portion of the LH bellcrank assembly was sheared off. One of the tangs at the bottom of the bellcrank was also broken. When examined under a 10 power…NTSB CHI83IA446Incident · No injuriesIncident investigationFinal reportCessna 401A · Frankfort, ILThe right main landing gear collapsed during landing roll-the right main landing gear bellcrank was found to have failed in instantaneous overload. The rigging of main gear was improper.NTSB CHI82DA285Accident · No injuriesFinal reportCessna 310P · Marion, ILThe aircrafts right main landing gear collapsed during landing. The instructor and student were practicing touch and go landings when the accident occurred. Examination of the gear revealed the torque tube assembly (p/n 504-5010-8) was broken at the forward…