NTSB investigations, OH
6 cases where the first occurrence was “Main gear collapsed”.
Cases per year
| 1983 | 1 |
|---|---|
| 1988 | 1 |
| 1989 | 1 |
| 1992 | 1 |
| 1999 | 1 |
| 2000 | 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\" = 'OH' 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" = 'OH' 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 NYC00LA190Accident · No injuriesLimited investigationFinal reportSpartan 7W · Jefferson, OHThe overload failure of the left main gear strut housing.NTSB NYC99LA051Accident · No injuriesLimited investigationFinal reportCessna 650 · Columbus, OHThe collapse of the airplane's right main landing gear due to inadequate design by its manufacturer.NTSB NYC92LA094Accident · No injuriesLimited investigationFinal reportCessna 310R · Cleveland, OHA failure of the left main gear's upper strut housing and down lock link assembly attach point.NTSB CHI89LA106Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Elyria, OHFailure (shearing) of the right main gear attaching bolts. A contributing factor was: failure of the owner/operator to comply with service bulletin #673B.NTSB ATL88LA193Accident · No injuriesLimited investigationFinal reportCessna 195A · Port Clinton, OHDuring touchdown, the pilot noted a vibration and the airplane veered to the left. He attempted to correct by applying right brake and rudder, but the airplane continued off the left side of the runway into the grass. The right landing gear strut failed at…NTSB CHI83LA142Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Columbus, OHThe plt had purchased the acft on 2/28/83. From that date until the day of the accident on 3/16/83, he had problems with the landing gear. When he attempted to retract the gear after takeoff on the day of the accident, the indicators showed that the gear had…