NTSB investigations, MO
6 cases where the first occurrence was “Gear collapsed”.
Cases per year
| 1983 | 1 |
|---|---|
| 1984 | 1 |
| 1991 | 1 |
| 1995 | 1 |
| 2006 | 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.\"eventStateOrRegion\" = 'MO' 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\" = 190)
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" = 'MO' 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" = 190) 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 CHI08LA044Accident · No injuriesLimited investigationFinal reportAero Commander GA-500-B · Kansas City, MOThe pilot delayed lowering the landing gear in the landing sequence and the main gear were not in the down and locked position upon touchdown.NTSB CHI06LA089Accident · No injuriesLimited investigationFinal reportBeech 95-55 · Sikeston, MOThe inadvertent landing gear retraction by the pilot during an after landing taxi.NTSB CHI95LA224Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Springfield, MOThe collapse of the left main landing gear for an undetermined reason.NTSB CHI91LA105Accident · No injuriesLimited investigationFinal reportCessna 401 · St. Louis, MOThe landing gear locking mechanism (bell crank) had fractured.NTSB MKC84LA137Accident · No injuriesLimited investigationFinal reportBeech BE95A55 · Springfield, MOThe acft landing gear collapsed during landing. The plt said he was following a metroliner & put the gear handle 'down' but does not remember the gear indicators. He reduced the throttles to about 11 inches of manifold pressure & does not remember hearing a…NTSB MKC83LA080Accident · No injuriesLimited investigationFinal reportMooney M20F · Springfield, MOThe aircraft sustained damage when the left main and nose gears collapsed while the pilot was taxiing in from landing. The aircraft landed on runway 31 and had begun a right turn onto a taxiway when the nose gear and then the left main gear retracted. The…