NTSB investigations, 1991
9 cases where the first occurrence was “Gear collapsed”.
Cases per year
| 1982 | 8 |
|---|---|
| 1983 | 12 |
| 1984 | 12 |
| 1985 | 17 |
| 1986 | 11 |
| 1987 | 7 |
| 1988 | 4 |
| 1989 | 11 |
| 1990 | 6 |
| 1991 | 9 |
| 1992 | 7 |
| 1993 | 4 |
| 1994 | 18 |
| 1995 | 11 |
| 1996 | 6 |
| 1997 | 11 |
| 1998 | 9 |
| 1999 | 21 |
| 2000 | 9 |
| 2001 | 14 |
| 2002 | 18 |
| 2003 | 11 |
| 2004 | 6 |
| 2005 | 12 |
| 2006 | 13 |
| 2007 | 18 |
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\" = 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 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" = 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 NYC92LA015Accident · No injuriesLimited investigationFinal reportCessna 150L · Sanford, METhe failure of the nose wheel through bolt as a result of fatigue cracking.NTSB CHI91LA261Accident · No injuriesLimited investigationFinal reportPiper PA-32-R300 · Lake In Hills, ILThe pilot's failure to perform an adequate preflight by assuring the gear lever was in the down and locked position.NTSB CHI91LA262Accident · No injuriesLimited investigationFinal reportCessna 310 · Plattsmouth, NEImproper maintenance by the owner/pilot. A factor related to the accident was the built-up of corrosion on he landing gear retraction system.NTSB ANC91LA118Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Emmonak, AKThat the pilot inadvertently retracted the landing gear during the takeoff roll. Contributing to this accident was that the checklist was not followed.NTSB CHI91LA201Accident · No injuriesLimited investigationFinal reportPiper PA-28-201R · Wheeling, ILThe pilot in command's inadequate pre-flight inspection. Factors contributing to this accident were the landing gear lever not being engaged, the use of an inadequate procedure by the pilot-in-command, and the inadvertent gear retraction during takeoff roll.NTSB DEN91LA054Accident · No injuriesLimited investigationFinal reportBeech H35 · Greeley, COThe pilot's inadvertent activation of the landing gear switch causing the landing gear to collapse while the aircraft was still on the landing roll.NTSB LAX91LA142Accident · No injuriesLimited investigationFinal reportCessna 421 · El Monte, CAThe pilot retracting the landing gear during the landing roll.NTSB CHI91LA105Accident · No injuriesLimited investigationFinal reportCessna 401 · St. Louis, MOThe landing gear locking mechanism (bell crank) had fractured.NTSB SEA91TA003Accident · No injuriesFinal reportPiper PA-34 · Pinedale, WYThe pilot's failure to attain proper runway alignment during landing. A contributing factor was a snow covered runway.