NTSB investigations, AK
17 cases where the first occurrence was “Gear collapsed”.
Cases per year
| 1983 | 1 |
|---|---|
| 1985 | 1 |
| 1987 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1994 | 4 |
| 1996 | 1 |
| 1998 | 1 |
| 1999 | 2 |
| 2001 | 1 |
| 2002 | 2 |
| 2007 | 1 |
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 c.\"eventStateOrRegion\" = 'AK' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'AK' AND c."eventCountry" = 'USA' 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 ANC07LA066Accident · No injuriesLimited investigationFinal reportBeech 58 · Northway, AKThe collapse of the landing gear during the landing roll for an undetermined reason.NTSB ANC03LA012Accident · No injuriesLimited investigationFinal reportCurtiss-Wright CW-46 · Fairbanks, AKThe failure of the right main landing gear locking device to engage, which allowed the right main landing gear to collapse during taxi from landing.NTSB ANC02LA024Accident · No injuriesLimited investigationFinal reportTaylorcraft F-19 · Dillingham, AKThe collapse of the airplane's right main landing gear, for an undetermined reason, during the landing roll.NTSB ANC01LA145Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Tanana, AKAn unlocked landing gear mechanism during landing roll. A factor associated with the accident was an electrical system failure.NTSB ANC00LA002Accident · No injuriesLimited investigationFinal reportCessna A185E · Yakutat, AKThe pilot's selection of an unsuitable landing area. A factor associated with the accident was soft terrain.NTSB ANC99LA042Accident · No injuriesLimited investigationFinal reportCessna 180 · Iliamna, AKThe improper installation of the main landing gear attaching bolt by maintenance personnel, which resulted in total failure of the bolt and collapse of the landing gear.NTSB ANC98IA096Incident · No injuriesIncident investigationFinal reportCessna 185 · Homer, AKThe failure of the right main landing gear leg due to corrosion pitting and fatigue.NTSB ANC96LA062Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Togiak, AKfatigue failure of the right main landing gear strut.NTSB ANC94LA128Accident · No injuriesLimited investigationFinal reportMaule M5 · Port Alsworth, AKThe pilot's selection of unsuitable terrain.NTSB ANC94LA125Accident · No injuriesLimited investigationFinal reportCessna 170B · Fort Yukon, AKThe fatigue failure of the right main landing gear spring.NTSB ANC94LA114Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Deadhorse, AKThe separation of the landing gear tube at the spindle due to corrosion. An inadequate annual inspection was a factor in the accident.NTSB ANC94LA044Accident · No injuriesLimited investigationFinal reportPiper J3 · Denali Nat'L Pk, AKThe failure of the landing gear bolt attachment fitting due to fatigue.NTSB ANC91LA118Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Emmonak, AKThat the pilot inadvertently retracted the landing gear during the takeoff roll. Contributing to this accident was that the checklist was not followed.NTSB ANC90LA128Accident · No injuriesLimited investigationFinal reportCessna 337 · Kustatan River, AKPilot-in-command's failure to assure that the rear engine developed full takeoff power and to attain takeoff airspeed. Contributing factors were the terrain conditions.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.NTSB ANC85LA156Accident · No injuriesLimited investigationFinal reportCessna 210 · Northway, AKThe right main gear collapsed during landing. Post accident examination of the landing gear disclosed the rear door actuator rod failed and the gear door was bent. The right hand main gear downlock failed in an area which appeared to have been previously…NTSB ANC83IA058Incident · No injuriesIncident investigationFinal reportPiper PA34-200T · Palmer, AKDuring touch go landing the student pilot placed the landinggear handle in the up polition while still on the ground, and immediately placed it in the down position. The gear collapsed. The instructor stated that the student appeared to be fatigued.