NTSB investigations, 2000
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\") = 2000
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") = 2000 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 SEA01LA034Accident · No injuriesLimited investigationFinal reportGrumman G-44 · Hermiston, ORThree out of four snap rings holding the pistons for the landing gear actuators failed which resulted in the landing gear collapsing during landing. On ground collision with a berm was a factor.NTSB LAX00LA303Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Reno, NVThe fatigue failure and separation of the right main landing gear.NTSB SEA00LA134Accident · No injuriesLimited investigationFinal reportCessna 182 · Snohomish, WAThe right main landing gear failed for undetermined reasons.NTSB CHI00LA161Accident · No injuriesLimited investigationFinal reportCessna T210N · Indianapolis, INthe unlocked main landing gear and the manual gear extension not performed by the pilot. The electrical system failure was a contributing factor.NTSB SEA00LA077Accident · No injuriesLimited investigationFinal reportPZL-Bielsko Jantar 2A · Hood River, ORThe pilot's failure to maintain directional control of the glider after its wing came in contact with long grass growing on the runway surface. Factors include the pilot's improper decision to attempt a landing on a runway with known directional control…NTSB FTW00LA121Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Fayetteville, ARThe failure of the inboard half of the right main landing gear wheel as a result of fatigue.NTSB SEA00LA049Accident · No injuriesLimited investigationFinal reportCessna 180 · Port Townsend, WAThe pilot's failure to adequately compensate for changing wind conditions during the landing roll in a tailwheel-equipped aircraft. Factors include a variable, shifting wind that changed from a quartering headwind to a quartering tailwind just prior to the…NTSB LAX00LA113Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Selma, CAThe failure and separation of the right landing gear axle during taxi from landing for undetermined reasons.NTSB MIA00LA072Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Palmetto, FLFailure for undetermined reasons of the right main landing gear strut during landing resulting in collapse of the right main landing gear.