NTSB investigations: Continental 0-300 series, AK

16 cases on aircraft whose registry engine model is Continental 0-300 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

19842026
NTSB investigations: Continental 0-300 series, AK per year, 1984–2026: 16 cases
19841
19871
19883
19902
19911
19921
19962
19971
19981
20022
20031

Latest 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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17022')
      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.

NTSB ANC03CA097Accident · No injuriesData collectionFinal reportCessna 170B · Sparrevohn, AKThe pilot's inadequate compensation for a crosswind, which resulted in collapse of the left main landing gear during the takeoff roll. A factor was the crosswind.Aug 18, 2003 · N8016A · Substantial damageNTSB ANC02LA105Accident · No injuriesLimited investigationFinal reportCessna 172H · Fairbanks, AKThe pilot's failure to maintain directional control during the takeoff roll, which resulted in the airplane exiting the runway and colliding with objects. Factors contributing to the accident were the rough and uneven runway, and the premature lift-off of the…Aug 27, 2002 · N3752F · Substantial damageNTSB ANC02LA096Accident · No injuriesLimited investigationFinal reportCessna 170 · Soldotna, AKThe pilot's inadequate recovery from a bounced landing, and his failure to maintain directional control of the airplane. A factor contributing to the accident was the pilot's excessive braking which resulted in a nose over.Aug 15, 2002 · N2558D · Substantial damageNTSB ANC98LA065Accident · No injuriesLimited investigationFinal reportCessna 172 · Naknek, AKThe pilot's inadequate compensation for wind conditions. A factor associated with this accident was a crosswind.Jun 6, 1998 · N8092B · Substantial damageNTSB ANC97LA043Accident · No injuriesLimited investigationFinal reportCessna 170B · Fairbanks, AKThe pilot's failure to maintain directional control during the takeoff roll.Mar 16, 1997 · N3486C · Substantial damageNTSB ANC96LA108Accident · No injuriesLimited investigationFinal reportCessna 170B · Northway, AKThe pilot's failure to maintain directional control of the airplane during landing.Jul 30, 1996 · N4464B · Substantial damageNTSB ANC96LA090Accident · No injuriesLimited investigationFinal reportCessna 170B · Fairbanks, AKThe pilot's selection of unsuitable terrain for landing and the failure to maintain directional control of the airplane. A factor in the accident was an airstrip that was rough and uneven.Jun 17, 1996 · N2848C · Substantial damageNTSB ANC92LA066Accident · No injuriesLimited investigationFinal reportCessna C-170B · Talkeetna, AKLoss of control on landing roll due to the pilot's failure to maintain proper alignment, resulting in collision with terrain during an uncontrolled ground loop/swerve. A factor relating to the accident was the crosswind weather conditions.May 4, 1992 · N2746D · Substantial damageNTSB ANC91LA129Accident · No injuriesLimited investigationFinal reportCessna 172 · Montague Island, AKThe pilot's failure to maintain control of the airplane during the landing roll. A factor was the unsuitable terrain selected for landing by the pilot, which was loose gravel, rough and uneven.Aug 19, 1991 · N7966B · Substantial damageNTSB ANC90LA067Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKThe pilot failed to maintain directional control of the airplane during the landing roll, which resulted in a ground swerve.May 6, 1990 · N4538C · Substantial damageNTSB ANC90LA050Accident · No injuriesLimited investigationFinal reportMaule M-4 · Anchorage, AKThe pilot's improper compensation for wind conditions and failure to maintain directional control. The unfavorable (variable) wind and snow covered terrain were related factors.Mar 31, 1990 · N4619T · Substantial damageNTSB ANC89FA028Accident · No injuriesField investigationFinal reportCessna 172 · Anchorage, AKThe 103 hour private pilot was in the process of demonstrating his Cessna 172 conventional gear airplane (tail-dragger) to a prospective purchaser, when he lost directional control during landing and nosed-over. The pilot reported that he had just touched…Dec 30, 1988 · N3752F · Substantial damageNTSB ANC88LA088Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKAfter touchdown on the airstrip the pilot lost control of the airplane. The airplane bounced. The airplane then exited the left side of the runway into a row of trees.Jul 10, 1988 · N4346B · Substantial damageNTSB ANC88DAG02Accident · No injuriesFinal reportCessna 172 · Willow, AKThe pilot stated that immediately upon touchdown, the airplane started sinking in (two feet) deep snow, and came to a stop in about 50 feet. The left wing and propeller struck the ground. The plt had overflown the arpt and saw the snow removal equipment about…Jan 9, 1988 · N8439X · Substantial damageNTSB ANC87LA147Accident · No injuriesLimited investigationFinal reportCessna 170B · Skwentna, AKThe pilot stated that during the take off roll he lost directional control of the aircraft causing the aircraft to nose over. He also indicated that the private strip was new and that the dirt rwy was wet and soft.Sep 15, 1987 · N3410D · Substantial damageNTSB ANC84LA188Accident · No injuriesLimited investigationFinal reportMaule M-4 · King Salmon, AKThe plt stated that after he lifted the tail off the rwy the acft encountered a gust of wind and he lost control swerving into a ditch adjacent to the rwy.Sep 23, 1984 · N12023 · Substantial damage