NTSB investigations
406 cases where the first occurrence was “Main gear collapsed”.
Cases, newest first
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\" = 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."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 FTW82DA080Accident · No injuriesFinal reportCessna 421B · Eunice, LAShortly after touchdown during a landing. The left main gear collapsed. The aircraft then veered off the left side of the runway and struck a ditch. The right main and nose gear collapsed after striking the ditch. An examination of the left gear revealed that…NTSB CHI82FA059Accident · No injuriesField investigationFinal reportCessna 404 · Oshkosh, WIThe right main gear collapsed on landing. Investigation revealed that the rear trunnion pivot pin, P/N5741112-1, had moved aft & out of the trunnion. The pin had about 1 inch of white paint on the end of the pin that extended into the flap track area. The…NTSB FTW82DA056Accident · No injuriesFinal reportCessna 177RG · Artesia, NMWhile taxiing, the aircraft was lifted up on its right main gear by a gust of wind. When the aircraft settled back down, the left main inboard castering bolt sheared and the left main gear collapsed. The wind was gustng to 20 knots.NTSB FTW82DA054Accident · No injuriesFinal reportCessna T210N · Dryden, TXThe pilot observed the left main gear extend but did not check the landing gear position indicator. The main gear collapsed during landing roll while the nose gear remained down and locked. Inspection revealed the warning horn did not activate due to some…NTSB DEN82DA023Accident · No injuriesFinal reportBellanca 7GCBC · Havre, MTWhile taking off to help gather cattle, the right axle failed as the left wing was picked up by gusty winds. The plane spun around 180 degrees and flipped over. The pilot reported that the axles were not heavy enough for consistent rough field use.NTSB LAX82DA046Accident · No injuriesFinal reportAir Tractor 301 · Dos Palos, CADuring the takeoff roll the pilot decided that he was not going to clear an 8 foot chain-link fence at the end of the runway. He stated that he pulled the dump-gate, chopped the throttle, and put on the brake but the aircraft went into soft dirt and the right…