NTSB investigations, MI
14 cases where the first occurrence was “Main gear collapsed”.
Cases per year
| 1983 | 1 |
|---|---|
| 1984 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1998 | 2 |
| 1999 | 1 |
| 2004 | 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\" = 'MI' 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" = 'MI' 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 CHI06CA279Accident · No injuriesData collectionFinal reportMeyers MAC-145 · Manistique, MIThe pilot not verifying the landing gear selector position prior to starting the taxi.NTSB CHI05CA244Accident · No injuriesData collectionFinal reportCessna 414 · Drummond Island, MIThe right main gear collapsed due to undetermined reasons. A factor associated with the accident was the fence that the airplane contacted.NTSB CHI04LA199Accident · No injuriesLimited investigationFinal reportRockwell 114 · Grand Rapids, MIThe right main landing gear failed as a result of the fatigue fracture due to the casting defect (inclusion) during the manufacture process.NTSB CHI99LA291Accident · No injuriesLimited investigationFinal reportCessna 182 · Tecumseh, MIfracture of the right main landing gear strut.NTSB CHI98LA249Accident · No injuriesLimited investigationFinal reportCessna 190 · Pontiac, MIimproper procedures used during the replacement of the landing gear which resulted in pitting and corrosion of the gear spring.NTSB CHI98LA210Accident · Minor injuriesLimited investigationFinal reportCessna 180A · Bay City, MIa fatigue failure of the left nose gear caster bolt which resulted in a separation of the nose gear during landing.NTSB CHI96IA125Incident · No injuriesIncident investigationFinal reportATR 42 · Traverse City, MIimproper use of procedures by maintenance personnel at an overhaul facility during overhaul of the landing gear, allowing corrosion to occur on the barrel lugs of the landing gear, which subsequently led to fatigue cracking of the lugs and eventual collapse…NTSB CHI95LA147Accident · No injuriesLimited investigationFinal reportCessna 172M · Brooklyn, MIFatigue failure of the left main landing gear. Factors relating to the accident were: the pilot's improper flare for landing, and soft terrain.NTSB CHI91LA133Accident · No injuriesLimited investigationFinal reportCessna TR182 · Jackson, MIFailure to the pilot to assure gear extension. Factors related to the accident were the electrical failure due to a seized alternator and diverted attention by the pilot.NTSB CHI90LA085Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Pontiac, MIOverload failure of the left main landing gear attach bolts for an undetermined reason.NTSB CHI87LA089Accident · No injuriesLimited investigationFinal reportCessna 182F · Pontiac, MIWhile the acft was being taxied to a hangar after landing, the left main gear collapsed. An investigation revealed the left main landing gear spring strut, pn 0741601-1, had failed where it was clamped to the fuselage. A metallurgical exam of the fracture…NTSB CHI86LA222Accident · No injuriesLimited investigationFinal reportCessna 310G · Ypsilanti, MIThe left main gear collapsed and the acft veered off the left side of the runway during the landing roll at an groundspeed of aprx 30 KTS. Inspection of the landing gear disclosed a bent push pull tube.NTSB CHI84LA327Accident · No injuriesLimited investigationFinal reportGulfstream 690 · Detroit, MIOn right engine start the right main landing gear collapsed. The gear handle was found in the down position after the accident. Functional and bench check of the actuating components revealed no discrepancies.NTSB CHI84LA033Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Burnips, MIReportedly, the plt had consumed 4 beers after 2200 EDT, while at the bostwick lake inn, then consumed another beer after he left the inn. At aprx 0330 EDT, he & a passenger took off from an unlit arpt. The plt stated that shortly after takeoff, he became…