NTSB investigations, 2000
6 cases where the first occurrence was “Nose gear collapsed”.
Cases per year
| 1982 | 22 |
|---|---|
| 1983 | 16 |
| 1984 | 16 |
| 1985 | 15 |
| 1986 | 9 |
| 1987 | 14 |
| 1988 | 10 |
| 1989 | 9 |
| 1990 | 10 |
| 1991 | 3 |
| 1992 | 5 |
| 1993 | 16 |
| 1994 | 5 |
| 1995 | 6 |
| 1996 | 9 |
| 1997 | 10 |
| 1998 | 3 |
| 1999 | 4 |
| 2000 | 6 |
| 2002 | 4 |
| 2003 | 4 |
| 2004 | 3 |
| 2005 | 5 |
| 2006 | 4 |
| 2007 | 6 |
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\" = 192)
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" = 192) 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 DEN01LA006Accident · No injuriesLimited investigationFinal reportNorth American T-28D · Heber City, UTthe failure of the nose wheel landing gear shimmy damper, which resulted in failure and collapse of the nose wheel landing gear during landing roll.NTSB MIA00IA266Incident · No injuriesIncident investigationFinal reportBeech 1900C · Miami, FLThe excessive clearance between the shuttle valve and the shuttle bore in the end cap of the left main landing gear actuator for undetermined reasons either during overhaul or manufacturing resulting in failure to build hydraulic pressure using the emergency…NTSB NYC00LA202Accident · No injuriesLimited investigationFinal reportCessna 172H · Rainelle, WVThe pilot's failure to maintain a proper decent rate. A factor was the up-sloping runway.NTSB DEN00LA060Accident · No injuriesLimited investigationFinal reportBeech B55 · Ogden, UTInadvertent landing gear retraction by person(s) undetermined. A factor was the inadequate supervision of the flight by the flight instructor.NTSB LAX00LA137Accident · No injuriesLimited investigationFinal reportGrumman American AG5B · Oakland, CAThe inadvertent porpoise and improper remedial action of the pilot during the landing attempt.NTSB DEN00LA036Accident · No injuriesLimited investigationFinal reportBeech B200 · Jackson, WYThe pilot misreading the visual approach lighting system, resulting in his failure to maintain proper alignment with the runway and his selection of an improper touchdown point. Factors were the low ceiling weather conditions and the snow covered runway.