NTSB investigations, ID
6 cases where the first occurrence was “Main gear collapsed”.
Cases per year
| 1985 | 1 |
|---|---|
| 1986 | 1 |
| 1991 | 1 |
| 1996 | 1 |
| 2002 | 2 |
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\" = 'ID' 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" = 'ID' 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 SEA02LA077Accident · No injuriesLimited investigationFinal reportCessna 177B · New Plymouth, IDThe pilot's use of unsuitable terrain (landing surface) at his privately owned landing site. A contribtuing factor was the soft area which the aircraft's right main wheel encountered.NTSB SEA02LA057Accident · No injuriesLimited investigationFinal reportCessna 340 · Idaho Falls, IDThe overload of the right main landing gear bellcrank, adjustable end fitting and clevis ears resulting in fractures and the subsequent gear collapse.NTSB SEA96LA197Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Challis, IDcorrosion in the left main landing gear cluster, which resulted in a failure of the left main landing gear. Inadequate inspection by undetermined maintenance personnel was a related factor.NTSB SEA91LA248Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Lewiston, IDThe pilot's failure to maintain directional control.NTSB SEA87LA010Accident · No injuriesLimited investigationFinal reportBritten-Norman BN-2A-20 · Lower Loon, IDThe plt diverted from his original destination due to weather. Upon landing at the alternate airport wiht a 7 knot tail wind, while using heavy braking on wet sod, the brakes locked. The acft veered to the right of the center placing the right main gear on…NTSB SEA85LA098Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Kendrick, IDThe plt stated that he had completed a spray application & was making a normal landing when the left main gear failed. Subsequently, the acft veered off the left side of the rwy & nosed over. AD 76-13-10, pertaining to a dye penetrant inspection of the main…