NTSB investigations: Continental 0-300 series

66 cases on aircraft whose registry engine model is Continental 0-300 series, where the defining event was Loss of control on ground. 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, newest first

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.\"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_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '230'))
  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 ERA12CA502Accident · No injuriesData collectionFinal reportMaule M-4C · Lincoln, METhe pilot's failure to maintain directional control during the landing roll.Aug 9, 2012 · N9838M · Substantial damageNTSB WPR12CA333Accident · No injuriesData collectionFinal reportCessna 170A · Ellensburg, WAThe pilot’s loss of directional control during the landing roll.Jul 29, 2012 · N4089A · Substantial damageNTSB WPR12CA153Accident · Minor injuriesData collectionFinal reportCessna 172 · Johnson Valley, CAThe pilot did not properly secure the airplane prior to rotating the propeller by hand, resulting in inadvertent movement of the airplane.Apr 3, 2012 · N6749A · Substantial damageNTSB WPR12CA132Accident · No injuriesData collectionFinal reportCessna 170B · San Jose, CAThe pilot did not maintain directional control during the landing roll.Mar 4, 2012 · N8245A · Substantial damageNTSB WPR11CA177Accident · No injuriesData collectionFinal reportCessna 172 · Republic, WAThe pilot’s failure to maintain directional control during the landing roll.Mar 31, 2011 · N7302A · Substantial damageNTSB CEN11CA122Accident · No injuriesData collectionFinal reportCessna 170B · Houston, TXThe pilot's failure to maintain directional control during landing. Contributing to the accident was the flight instructor's delayed remedial action.Dec 11, 2010 · N1634D · Substantial damageNTSB CEN10CA193Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Brook Park, MNThe pilot’s failure to maintain directional control during landing rollout in variable wind conditions.Apr 4, 2010 · N7884D · Substantial damageNTSB ANC10CA015Accident · No injuriesData collectionFinal reportCessna 172H · Nightmute, AKThe pilot's failure to maintain control of the airplane in a strong gusting wind, and his decision to taxi for takeoff in such conditions.Jan 23, 2010 · N3718F · Substantial damageNTSB WPR10CA062Accident · No injuriesData collectionFinal reportCessna 172 · Yucca Valley, CAThe pilot's inadequate compensation for the crosswind gusts and failure to maintain directional control of the airplane.Nov 21, 2009 · N8504B · Substantial damageNTSB ANC09CA039Accident · No injuriesData collectionFinal reportCessna 170B · Kenai, AKThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground-loop. A factor contributing to the accident was the pilot's diverted attention during the landing.May 12, 2009 · N3469C · Substantial damageNTSB WPR09CA210Accident · No injuriesData collectionFinal reportCessna 172E · Tucson, AZThe pilot’s inadequate compensation for the gusting crosswinds.Apr 22, 2009 · N3880S · Substantial damageNTSB CEN09CA042Accident · No injuriesData collectionFinal reportCessna 172H · Ingleside, TXThe pilot's decision to land in crosswind conditions, leading to his inability to maintain directional control. Contributing to the accident were the crosswinds.Oct 27, 2008 · N1714F · Substantial damageNTSB ANC08LA094Accident · No injuriesLimited investigationFinal reportCessna 172 · Anchorage, AKThe pilot's failure to maintain directional control during the landing flare/touchdown, which resulted in a runway excursion and collapse of the nose gear.Aug 2, 2008 · N2357U · Substantial damageNTSB SEA08CA132Accident · No injuriesData collectionFinal reportCessna 172 · Big Timber, MTThe student pilot's failure to maintain an adequate airspeed during landing which resulted in a stall.May 10, 2008 · N8103E · Substantial damageNTSB ANC08CA064Accident · No injuriesData collectionFinal reportCessna 172 · Chugiak, AKThe pilot's failure to maintain control of the airplane during the landing roll. Contributing to the accident was an inadvertent ground loop/swerve.May 10, 2008 · N7598T · Substantial damageNTSB CHI08CA090Accident · No injuriesData collectionFinal reportCessna 172 · Apple River, ILThe pilot's inadequate compensation for wind conditions, and his failure to obtain/maintain directional control. Contributing factors were a crosswind and a snow bank.Mar 1, 2008 · N8366B · Substantial damage