NTSB investigations, 1993
5 cases where the first occurrence was “Complete gear collapsed”.
Cases per year
| 1982 | 14 |
|---|---|
| 1983 | 18 |
| 1984 | 16 |
| 1985 | 10 |
| 1986 | 2 |
| 1987 | 5 |
| 1988 | 2 |
| 1989 | 3 |
| 1990 | 3 |
| 1991 | 2 |
| 1993 | 5 |
| 1994 | 1 |
| 1998 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 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 year(c.\"eventDate\") = 1993
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\" = 194)
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") = 1993 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" = 194) 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 NYC94LA016Accident · No injuriesLimited investigationFinal reportBeech 58 · Millville, NJthe pilot's inadvertent actuation of the landing gear lever during the landing roll, resulting in the retraction of the landing gear on the runway.NTSB FTW93LA237Accident · No injuriesLimited investigationFinal reportBeech 58 · Little Rock, ARThe inadvertent landing gear retraction by the pilot. A factor was the pilot's negative habit interference.NTSB LAX93LA291Accident · No injuriesLimited investigationFinal reportPiper PA-39 · Thermal, CAthe pilot's inadvertent movement of the landing gear selector switch to the up position. A factor in the accident was the difference in cockpit switch layout between the PA23 and PA39 aircraft.NTSB NYC93LA121Accident · No injuriesLimited investigationFinal reportCessna 182Q · Randolph Center, VTThe pilot selected unsuitable terrain which resulted in collapse of the landing gear and the airplane nosing over. A contributing factor was a soft/wet runway.NTSB SEA93LA138Accident · No injuriesLimited investigationFinal reportBeech 60 · Bullfrog, UTInadvertent landing gear retraction.