NTSB investigations, 1993
16 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\") = 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\" = 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") = 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" = 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 MIA94LA022Accident · Minor injuriesLimited investigationFinal reportScott LONG-EZ · Hernando, FLThe failure of the nose gear down relay on the landing gear retraction/extension assembly for undetermined reasons, resulting in the collapse of the nose wheel on landing, and subsequent nose over.NTSB LAX93LA374Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Columbia, CAthe pilot's improper use of the elevator control during the takeoff ground roll which resulted in a porpoise and nose gear collapse. A factor in the accident was the pilot's low total experience and lack of total time in type.NTSB SEA93LA204Accident · No injuriesLimited investigationFinal reportCessna 182E · Quilcene, WAThe pilot's failure to maintain the proper airspeed and glidepath.NTSB ANC93LA162Accident · No injuriesLimited investigationFinal reportCessna 172 · Knik Glacier, AKThe pilot's improper inflight planning/decision, and his failure to attain the proper touchdown point. Factors were the rain and the rough/uneven terrain.NTSB CHI93LA262Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Branson, MOthe fractured nose gear retract arm which allowed the nose gear to collapse.NTSB CHI93LA255Accident · No injuriesLimited investigationFinal reportCessna 182 · Prairie City, IAthe pilot's premature liftoff. Factors in the accident are the soft and wet sod runway.NTSB ANC93LA083Accident · No injuriesLimited investigationFinal reportBeech 56TC · Chistochina, AKThe pilot's improper decision to land on a rough airstrip.NTSB ANC93IA084Incident · No injuriesIncident investigationFinal reportBoeing 737-200 · Anchorage, AKThe failure of the nose landing gear inner cylinder from an overload/overstress condition.NTSB ANC93IA076Incident · No injuriesIncident investigationFinal reportCessna 310 · Kodiak, AKThe failure of the nose gear idler bell crank due to overstress by an undetermined source.NTSB ANC93LA068Accident · No injuriesLimited investigationFinal reportCessna 402B · Kivalina, AKThe pilot's failure to check the condition of the runway before takeoff. The soft runway condition was a factor in the accident.NTSB MIA93IA120Incident · No injuriesIncident investigationFinal reportPiper PA-44-180 · Daytona Beach, FLFatigue failure of the drag link assembly bolt.NTSB LAX93LA197Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Lakeport, CAthe student pilot's misjudging the landing flare altitude. A factor relating to this accident was the student pilot's lack of total experience.NTSB DEN93IA050Incident · No injuriesIncident investigationFinal reportPiper PA-34-200 · Boulder, CONot determined.NTSB CHI93IA110Incident · No injuriesIncident investigationFinal reportFokker 100 · Chicago, ILFailure of the company station manager to follow proper dispatch procedures, and ice accumulation on the nose gear locking mechanism. Factors related to the incident were: wet snow (slush) on the runway at the departure airport, and inadequate design which…NTSB ANC93LA038Accident · No injuriesLimited investigationFinal reportCessna U206A · Willow, AKThe abrupt aircraft handling by the pilot in command. Factors were the collapse of the nose gear and the soft, snow covered terrain.NTSB FTW93LA066Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXThe pilot's inadequate flare and the improper recovery from a bounced landing