NTSB investigations, NY
7 cases where the first occurrence was “Main gear collapsed”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1989 | 1 |
| 1993 | 1 |
| 1995 | 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\" = 'NY' 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" = 'NY' 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 NYC95LA201Accident · No injuriesLimited investigationFinal reportCessna 310B · Monticello, NYfatigue failure of the right main landing gear during the landing, which resulted in a gear collapse, loss of directional control, and subsequent collision with an embankment.NTSB BFO93LA025Accident · No injuriesLimited investigationFinal reportCessna 172RG · White Plains, NYThe collapse of the left main landing gear for an undetermined reason.NTSB NYC89LA127Accident · No injuriesLimited investigationFinal reportCessna 150G · Hudson, NYFatigue failure of the right main strut.NTSB NYC86LA080Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Rochester, NYOn landing roll left gear collapsed, airplane swerved left, came to a stop. Airplane substantially damaged. No fire. No injuries.NTSB NYC85LA190Accident · No injuriesLimited investigationFinal reportNew Standard D-25 · Rhinebeck, NYThe acft was moving at about 30 mph when the gear collapsed. According to the plt, the landing gear leg fitting failed causing the gear to collapse.NTSB NYC83LA018Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Dansville, NYDuring landing the flange on the right main landing gear strut broke off allowing the shock cord to collapse.NTSB NYC82IA162Incident · No injuriesIncident investigationFinal reportPiper PA-38-112 · Westhampton Bea, NYWhile taxiing in from landing during a left turn, the right main landing gear collapsed.