NTSB investigations, 1998
9 cases where the first occurrence was “Main gear collapsed”.
Cases per year
| 1982 | 48 |
|---|---|
| 1983 | 27 |
| 1984 | 33 |
| 1985 | 23 |
| 1986 | 24 |
| 1987 | 20 |
| 1988 | 20 |
| 1989 | 33 |
| 1990 | 14 |
| 1991 | 13 |
| 1992 | 21 |
| 1993 | 21 |
| 1994 | 9 |
| 1995 | 10 |
| 1996 | 9 |
| 1997 | 17 |
| 1998 | 9 |
| 1999 | 10 |
| 2000 | 6 |
| 2001 | 6 |
| 2002 | 9 |
| 2003 | 5 |
| 2004 | 3 |
| 2005 | 4 |
| 2006 | 7 |
| 2007 | 5 |
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\") = 1998
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\" = 191)
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") = 1998 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" = 191) 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 LAX99LA016Accident · No injuriesLimited investigationFinal reportCessna 208B · Lahaina, HIStructural failure of the main landing gear strut due to metallurgical fatigue. The fatigue cracks originated at an internal structural flaw placed in the part during manufacture.NTSB MIA98LA248Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Titusville, FLThe collapse of the right main landing gear for undetermined reasons. A contributing factor was the pilot's failure to execute the emergency gear extension procedure.NTSB ANC98LA141Accident · No injuriesLimited investigationFinal reportChristen Industries A-1 Husky · Selawik, AKThe pilot's inadequate compensation for the crosswind conditions. Factors in this accident were a crosswind, the pilot's lack of certification, and his inadequate fuel consumption calculations.NTSB CHI98LA249Accident · No injuriesLimited investigationFinal reportCessna 190 · Pontiac, MIimproper procedures used during the replacement of the landing gear which resulted in pitting and corrosion of the gear spring.NTSB NYC98LA137Accident · No injuriesLimited investigationFinal reportCessna 152 · Pottstown, PAThe student pilot's excessive application of the right brake, resulting in a ground loop.NTSB CHI98LA282Accident · No injuriesLimited investigationFinal reportCessna 310R · Cahokia, ILThe collapse of the left main landing gear during landing roll for undetermined reasons.NTSB CHI98LA210Accident · Minor injuriesLimited investigationFinal reportCessna 180A · Bay City, MIa fatigue failure of the left nose gear caster bolt which resulted in a separation of the nose gear during landing.NTSB MIA98LA123Accident · No injuriesLimited investigationFinal reportCessna 402B · West Palm Beach, FLthe pilot allowed the airplane to improperly touchdown on the right main landing gear, resulting in the gear collapsing, and subsequent impact with runway visual range equipment.NTSB SEA98LA051Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Kalispell, MTThe pilot's failure to maintain adequate crosswind correction during landing. A factor was a crosswind.