NTSB investigations, OR
10 cases where the first occurrence was “Gear collapsed”.
Cases per year
| 1984 | 1 |
|---|---|
| 1994 | 1 |
| 1996 | 2 |
| 1999 | 2 |
| 2000 | 2 |
| 2003 | 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\" = 'OR' 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" = 'OR' 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 LAX07LA158Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Eugene, ORCollapse of the landing gear during landing for undetermined reasons.NTSB SEA03LA063Accident · No injuriesLimited investigationFinal reportHerb Six Northstar · Medford, ORThe compressive buckling and collapse of the right main landing gear.NTSB SEA01LA034Accident · No injuriesLimited investigationFinal reportGrumman G-44 · Hermiston, ORThree out of four snap rings holding the pistons for the landing gear actuators failed which resulted in the landing gear collapsing during landing. On ground collision with a berm was a factor.NTSB SEA00LA077Accident · No injuriesLimited investigationFinal reportPZL-Bielsko Jantar 2A · Hood River, ORThe pilot's failure to maintain directional control of the glider after its wing came in contact with long grass growing on the runway surface. Factors include the pilot's improper decision to attempt a landing on a runway with known directional control…NTSB SEA99LA088Accident · No injuriesLimited investigationFinal reportRyan Navion B · Klamath Falls, ORThe pilot's failure to reinstall the engine oil filler cap during preflight, resulting in engine oil loss and the necessity for an immediate landing.NTSB SEA99LA053Accident · No injuriesLimited investigationFinal reportBeech 35-C33 · Hillsboro, ORA landing gear collapse for undetermined reasons.NTSB SEA96LA162Accident · No injuriesLimited investigationFinal reportConkey/Wapelhorst Lancair 235 · Cottage Grove, ORrelease of the main landing gear locking mechanism for undetermined reason(s).NTSB SEA96LA127Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Aurora, ORinadvertent retraction of the landing gear by the pilot during landing.NTSB SEA95LA003Accident · No injuriesLimited investigationFinal reportCessna 210 · Bend, ORThe failure of the landing gear downlock mechanism to engage due to undetermined reasons.NTSB SEA84LA189Accident · No injuriesLimited investigationFinal reportMooney M20E · Scappoose, ORPlt lowered gear in traffic pattern and gear down and locked green light was received. Plt failed to check the gear bar indicator. Acft touched down with gear extended 1/4 of the way. Inspection revealed landing gear motor bearingswere worn out.