NTSB investigations
11 cases where the first occurrence was “Other gear collapsed”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 4 |
| 1984 | 1 |
| 1985 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 2007 | 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.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 195) 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."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 195) 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 CHI07LA168Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Lakewood, WIThe amphibian nose wheel strut assembly separated due to an overload fracture as a result of the manufacturer's inadequate design.NTSB FTW96TA398Accident · Minor injuriesFinal reportHughes 269C · Houston, TXcompany maintenance personnel not complying with maintenance procedures and directives to inspect the helicopter's skids, which allowed the right skid to wear beyond the manufacturer's tolerances.NTSB MIA95LA002Accident · No injuriesLimited investigationFinal reportCessna 421B · Stuart, FLThe improper rigging of the landing gear safety squat switch by other maintenance personnel. Contributing to the accident was the contamination of the gear squat switch with corrosion and water.NTSB LAX92IA390Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-11 · Yuma, AZAn unstable interaction between the center body main landing gear and the brake system.NTSB CHI85LA095Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Indianapolis, INPlt stated the landing gear was lowered on final apch at an airspeed of 148 KTS and a gear down & locked indication was received. Plt continued to state the acft settled closer to the rwy then usual during the landing flare and when the acft was nearing a…NTSB NYC84LA262Accident · No injuriesLimited investigationFinal reportBeech BE-55 · Newport, RIThe plt extended the downwind leg of his landing traffic pattern to allow an acft ahead of him to land with the appropiate spacing between acft. The plt stated that just prior to touchdown he 'lowered the landing gear (too late).' In his recommendation for…NTSB FTW84IA094Incident · No injuriesIncident investigationFinal reportSikorsky S76A · Cameron, LAThe helicopter was on initial climb when the #1 engine failed explosivly. A post explosion fire ensued and both fire bottles were utilized to no avail. During landing the gear collapsed and the acft settled on its belly. The cause of the engine failure is…NTSB LAX83LA403Accident · No injuriesLimited investigationFinal reportBell 206-B3 · Avenal, CAThe plt was demonstrating autorotative landings in a helicopter equipped with high skid landing gear. During his 4th autorotation, he made a straight-in apch & touched down on level, smooth terrain. As the helicopter was stopping, the high skid rotated…NTSB CHI83IA162Incident · No injuriesIncident investigationFinal reportDouglas DC-8-71 · Minneapolis, MNWhile in curise flight a tire on theleft main landing gear blew out. On landing roll a fire erupted in the area of the left main landing gear, which was extinguished by airport crash rescue personal.NTSB DEN83IA083Incident · No injuriesIncident investigationFinal reportBoeing 737-200 · Denver, CODuring takeoff the inboard left main landing gear tire & wheel departed the acft. The flight returned and landed withoutfurther incident. Examination of the wheel rim revealed multiple fatigue cracks in the rim.NTSB ATL83LA064Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2 · Columbia, SCOn landing a scraping sound was heard and a go-around was performed. While on downwind, for the second landing, the gear handle was observed in the gear-up position. The gear was lowered and an uneventful landing was made.