NTSB investigations, 1992
8 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\") = 1992
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") = 1992 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 SEA93LA027Accident · No injuriesLimited investigationFinal reportSwearingen SA-226TC · Billings, MTFailure of a gear door roller, which necessitated a gear up landing. Factors include inadequate lubrication.NTSB ATL93FA021Accident · No injuriesField investigationFinal reportHawker Siddeley DH.125-400A · Nashville, TNThe company mechanic's improper preflight of the aircraft, resulting in a foreign object (flashlight) being left in the nose gear well.NTSB CHI92FA290Accident · No injuriesField investigationFinal reportBeech B55 · Joliet, ILThe pilot's inadvertent wheels up landing.NTSB LAX92LA287Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Tucson, AZThe failure of the student to extend the landing gear prior to landing and the failure of the flight instructor to properly supervise the conduct of the flight.NTSB SEA92LA128Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Seattle, WAThe pilot's failure to follow procedures. A factor to the accident was: diverted attention.NTSB CHI92IA141Incident · No injuriesIncident investigationFinal reportPiper PA-23-250 · Valentine, NEThe failure of the pilot in command to extend the landing gear and the inattentive FAA inspector (check airman). Associated factors are the inoperative landing gear warning system, the inadequate preflight inspection by the pilot and FAA inspector, and the…NTSB MIA92IA100Incident · No injuriesIncident investigationFinal reportCessna 402C · Miami, FLThe total failure of the main landing gear uplock and sequencing valve for undetermined reasons.NTSB DEN92LA030Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Monte Vista, COOperation of the aircraft with known deficiencies in equipment by the pilot in command, and jammed landing gear extension mechanisms due to corrosion.