NTSB investigations, 1996
9 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\") = 1996
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") = 1996 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 LAX97LA052Accident · No injuriesLimited investigationFinal reportCessna 152 · Redlands, CAthe pilot's improper landing flare and recovery from a subsequent bounced landing.NTSB ANC96LA152Accident · No injuriesLimited investigationFinal reportCessna 206F · Talkeetna, AKThe disconnection of the nosegear scissors assembly due to the loss of a retainer bolt.NTSB LAX96IA300Incident · No injuriesIncident investigationFinal reportDouglas DC-9-51 · Honolulu, HIImproper installation of a flexible hydraulic hose by company maintenance personnel and inadequate inspection of the work by company inspectors which resulted in the loose hose becoming entangled in the nose gear linkage, preventing complete extension of the…NTSB ANC96LA115Accident · No injuriesLimited investigationFinal reportde Havilland DHC-4 · New Stuyahok, AKThe collapse of the nosegear precipitated by the failure of the hydraulic nosegear drag strut locking actuator.NTSB SEA96LA140Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Jackson, WYAn improper screw installation by an unknown individual into the instrument panel, which restricted movement of the gear handle resulting in premature disengagement of the normal landing gear extension system. A factor was one or more improperly adjusted nose…NTSB ANC96IA077Incident · No injuriesIncident investigationFinal reportCessna 206 · Kodiak, AKThe pilot's selection of unsuitable terrain for landing. Factors in the accident were: soft terrain, the use of an oversize nose wheel tire, and the FAA's inadequate field approval process for tundra tires.NTSB CHI96LA166Accident · No injuriesLimited investigationFinal reportCessna 150 · Mcgregor, MNthe nose gear collapsed when it hit a soft spot in the runway.NTSB CHI96LA162Accident · No injuriesLimited investigationFinal reportSwearingen SA226TC · Fargo, NDthe flight crew did not comply with the gear down and lock checklist. The factors were a jammed nose gear and inattentive preflight planning/preparations by the pilot-in-command.NTSB LAX96LA123Accident · No injuriesLimited investigationFinal reportCessna U206 · Van Nuys, CAthe pilot's improper use of the elevator control, while landing.