NTSB investigations: Lycoming 0-320 series, WA
18 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “Loss of control - on ground/water”. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1984 | 1 |
|---|---|
| 1985 | 1 |
| 1987 | 1 |
| 1991 | 2 |
| 1992 | 1 |
| 1994 | 2 |
| 1995 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2003 | 1 |
| 2004 | 3 |
| 2005 | 1 |
| 2006 | 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\" = 'WA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41508')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
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" = 'WA' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41508')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 SEA06CA170Accident · No injuriesData collectionFinal reportPiper PA-22-20-150 · Auburn, WAThe flight instructor's delayed remedial action during the landing roll in response to the student's loss of directional control, which resulted in a ground loop. A factor associated with the accident was the student's failure to maintain directional control.NTSB SEA05LA185Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Mead, WASeparation of the tailwheel assembly spring resulting in a loss of directional control and subsequent collision with a berm. The berm was a factor in the accident.NTSB SEA04CA159Accident · No injuriesData collectionFinal reportBellanca 7GCAA · Sequim, WAAircraft control not maintained during the landing roll. A factor was the irrigation pipe.NTSB SEA04LA115Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Deer Park, WAThe flight instructor's delayed remedial action. Factors include the owner/pilot's failure to maintain directional control during the landing roll, and a warped/realigned fuselage that contributed to the sensitivity of the aircraft's response to pilot rudder…NTSB SEA04LA086Accident · No injuriesLimited investigationFinal reportPiper PA-22-20 · Shelton, WAThe pilot's failure to adequately compensate for wind conditions during landing. Factors include a crosswind, fracture/collapse of the landing gear hydrasorb and an improper weld on the landing gear assembly.NTSB SEA03LA103Accident · No injuriesLimited investigationFinal reportCessna 172P · Seattle, WAThe dual student's failure to maintain aircraft control and the flight instructor's delayed remedial action. Contributing factors were the crosswind condition and the flight instructor's lack of experience.NTSB SEA00LA114Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Ephrata, WAThe pilot-in-command's failure to maintain directional control during landing roll.NTSB SEA98LA144Accident · No injuriesLimited investigationFinal reportCessna 172P · Seattle, WAThe student pilot's failure to maintain directional control of the aircraft. Related factors were the student pilot's lack of total experience, and airport signs in the accident area.NTSB SEA98LA026Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Kenmore, WAthe pilot's inadequately planned approach and failure to maintain directional control. The pilot's lack of total experience in kind of aircraft and haze were factors.NTSB SEA95LA144Accident · Minor injuriesLimited investigationFinal reportChampion 7GCBC · Moses Lake, WAThe pilot's failure to maintain directional control during the landing and go around. The crosswind and gusty wind conditions were factors in the accident.NTSB SEA94LA227Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Everett, WAThe pilot failed to maintain directional control.NTSB SEA94LA220Accident · No injuriesLimited investigationFinal reportBeech 23 · Everett, WAThe student pilot's failure to maintain directional control, and his inadequate remedial action. Factors include a fence in the vicinity of the runway.NTSB SEA93LA021Accident · No injuriesLimited investigationFinal reportCessna 172M · Olympia, WAThe pilot's poor inflight decision, and excessive airspeed on final. Factors include a wet turf runway, and trees adjacent to the runway.NTSB SEA91LA201Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Yakima, WAThe loss of control by the private pilot and failure of the instructor pilot to perform remedial action.NTSB SEA91LA171Accident · No injuriesLimited investigationFinal reportCessna 172N · Vancouver, WAA hard landing by the pilot due to improper bounced landing recovery.NTSB SEA87LA113Accident · No injuriesLimited investigationFinal reportCessna 172P · Snohomish, WAThe pilot initiated a landing on a 2650 ft long runway in a 11-18 knot quartering tailwind condition. He flew the final approach too fast and flared prematurely. The acft floated down the rwy, landed hard and bounced twice. The plt lost control and the acft…NTSB SEA85LA172Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Moses Lake, WAA ground loop occurred during landing roll on rwy 36. The wind at touchdown was from 210 degs at 5 KTS. The twr did give the plt the current wind when the controller cleared him to land. The plt was aware that he would be landing with a left quartering tail…NTSB SEA84LA149Accident · No injuriesLimited investigationFinal reportCessna 172 · Everett, WAThe plt reported that during a landing, the acft encountered a gust of wind & ballooned. The airspeed decreased to 40 KTS & the acft dropped to the rwy. The plt applied full power & reduced the flaps from 40 deg to full up. The acft became airborne, but…