NTSB investigations
10 cases where the first occurrence was “Gear not retracted”.
Cases per year
| 1987 | 1 |
|---|---|
| 1989 | 2 |
| 1991 | 1 |
| 1992 | 2 |
| 1993 | 2 |
| 1994 | 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.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 197) 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."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 197) 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 BFO95LA007Accident · No injuriesLimited investigationFinal reportCessna A185F · N New Portland, METhe pilot's failure to verify the landing gear was in the proper position for landing.NTSB LAX94LA120Accident · No injuriesLimited investigationFinal reportCessna A185F · Valley Springs, CAthe pilot's failure to ensure that the landing gear was in the correct configuration for a water landing.NTSB ANC93LA131Accident · Minor injuriesLimited investigationFinal reportCessna 208 · Kodiak, AKThe pilot in command did not use the airplane checklist. A factor was his diverted attention to other mission related activities.NTSB SEA93LA124Accident · No injuriesLimited investigationFinal reportCessna A185F · Bellevue, WAFailure of the right main landing gear shock strut.NTSB CHI93IA035Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-8-71 · Chicago, ILAn improper repair of the retract pin boss area by the overhaul facility.NTSB FTW92LA141Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Graford, TXLoose jam nut on throttle cable. Factors were inadequate annual inspection and unsuitable terrain and water.NTSB CHI91LA064Accident · Minor injuriesLimited investigationFinal reportCessna 320E · Elkhart, INA fractured landing gear retraction assembly component and the pilot's improper emergency procedure.NTSB ANC89LA083Accident · No injuriesLimited investigationFinal reportCessna 185F · Toksook Bay, AKThe pilot inadvertently landed on water with the gear extended.NTSB SEA89FA092Accident · 1 fatalField investigationFinal reportde Havilland DHC-2 · Angoon, AKPilot failed to assure the landing gear on the amphibious floats were retracted for the water landing.NTSB LAX88LA004Accident · Minor injuriesLimited investigationFinal reportRepublic RC-3 · Clearlake, CAThe aircraft nosed over when the pilot made a water landing with the wheels extended. The pilot failed to use the landing checklist.