NTSB investigations, 1991
10 cases where the first occurrence was “Gear not extended”.
Cases per year
| 1983 | 2 |
|---|---|
| 1985 | 8 |
| 1986 | 1 |
| 1987 | 21 |
| 1988 | 17 |
| 1989 | 20 |
| 1990 | 16 |
| 1991 | 10 |
| 1992 | 8 |
| 1993 | 11 |
| 1994 | 9 |
| 1995 | 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 year(c.\"eventDate\") = 1991
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\" = 196)
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 year(c."eventDate") = 1991 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" = 196) 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 DEN92LA015Accident · No injuriesLimited investigationFinal reportBeech V35 · Erie, COAn inadvertent gear up landing when the pilot in command and designated examiner failed to use proper procedures. A factor was: failure of the landing gear extension/retraction motor.NTSB DEN92LA012Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Denver, COA false unsafe landing gear indication due to a frozen down lock switch. Factors were: icing conditions and low ceilings.NTSB ATL92LA004Accident · Serious injuriesLimited investigationFinal reportBeech F33A · Franklin, NCThe pilot's failure to lower the landing gear resulting in a gear up contact with the runway, and the eventual loss of control of the airplane.NTSB SEA91LA245Accident · No injuriesLimited investigationFinal reportCessna 210 · Arlington, WAThe pilot's failure to extend the landing gear. A factor contributing to the accident was the pilot's failure to utilize the landing checklist.NTSB SEA91LA214Accident · No injuriesLimited investigationFinal reportBeech 58TC · Kalispell, MTThe pilot's failure to extend the landing gear. A factor contributing to the accident was the pilot's failure to identtify a down and locked landing gear condition prior to touchdown.NTSB ATL91LA149Accident · No injuriesLimited investigationFinal reportPiper PA-31-325 · Spartanburg, SCThe pilot's failure to follow the checklist and extend the landing gear prior to touchdown.NTSB LAX91LA277Accident · No injuriesLimited investigationFinal reportFairchild SA227-AC · Visalia, CAThe instructor/pilot-in-command's failure to adequately supervise the flight and the second pilot's improper use of the checklist and failure to maintain crew coordination to ensure that the landing gear was extended. Contributing to the accident was the…NTSB ANC91IA046Incident · No injuriesIncident investigationFinal reportNihon YS-11A-600 · Anchorage, AKA jammed nose gear due to incorrect installation of the shear pin. Contributing to the accident was the insufficiently defined maintenance procedure.NTSB ATL91LA068Accident · No injuriesLimited investigationFinal reportCessna 210G · Metter, GAThe pilot's failure to extend the landing gear when his attention was diverted by radio conversation.NTSB MIA91LA070Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Orlando, FLFailure of the pilot to follow proper procedures resulting in a gearup landing.