NTSB investigations, 1987
7 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\") = 1987
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") = 1987 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 MIA88LA054Accident · No injuriesLimited investigationFinal reportCessna 310F · Opa Locka, FLThe plt stated that he had made three touch & go landings & on the fourth landing, while on rollout, the left main gear collapsed & the acft slid to a stop on the runway. Post crash examination of the landing gear revealed that the left main gear downlock rod…NTSB CHI88LA023Accident · No injuriesLimited investigationFinal reportCessna A150K · Elkhart, INThe plt of Cessna A150K, N8382M, was landing after the plt of another Cessna 150 had landed & had started to back-taxi up the same rwy. The plt of the other acft stated that she had announced her intentions to back taxi up the rwy & that she did not hear any…NTSB MIA87LA258Accident · No injuriesLimited investigationFinal reportAero Commander 560-F · Opa Locka, FLThe plt stated that he had just completed his third touch & go ldg when the gear collapsed while the acft was on the rwy. A plt/mechanic who assisted in removing the acft from the rwy stated that just after the accident, he peered into the cockpit & observed…NTSB ATL87LA150Accident · No injuriesLimited investigationFinal reportPiper PA-28-200 · Maxwell Afb, ALDuring the landing roll, the pilot lost directional control of the acft. The right main and nose gears collapsed. Inspection of the acft failed to reveal any system malfunction/failure.NTSB CHI87LA121Accident · No injuriesLimited investigationFinal reportBeech 58P · Evansville, INDuring landing roll-out the left main and nose gear collapsed. The pilot stated in his report that he does not recall touching any switches on roll-out. However, upon exiting the aircraft, the pilot reported that the landing gear relay was tripped open and…NTSB MIA87LA120Accident · No injuriesLimited investigationFinal reportCessna 210C · Ponch, PRThe acft was found abandoned in a sugar beet field with the landing gear collapsed. Information pertaining to the occupant(s), history of flt, and facts pertaining to the accident could not be determined. Injury index presumed.NTSB ANC87LA053Accident · No injuriesLimited investigationFinal reportCessna 185F · Skwentna, AKWhile taxiing on skis at excess speed, the pilot lost control of the airplane in a crosswind. The landing gear box failed causing substantial damage to the airframe and propeller.