OpenAirDocs.org

NTSB investigations: Continental 0-300 series, 2012

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

19642026

Where

Open the map

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 year(c.\"eventDate\") = 2012
    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'))
  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 ERA13LA075Accident · Serious injuriesLimited investigationFinal reportCessna 172F · Albemarle, NCThe student pilot's failure to remain clear of the airplane’s rotating propeller.Dec 2, 2012 · N8475U · Minor damageNTSB ERA13LA037Accident · No injuriesLimited investigationFinal reportCessna 172D · Indian Trail, NCThe pilot’s improper use of flaps for takeoff, which resulted in the airplane’s failure to attain adequate climb airspeed and subsequent collision will trees during takeoff.Oct 20, 2012 · N2879U · Substantial damageNTSB ERA13CA038Accident · No injuriesData collectionFinal reportCessna 172H · Weyers Cave, VAThe student pilot’s improper landing flare, which resulted in a hard landing.Oct 20, 2012 · N1431F · Substantial damageNTSB ANC13CA003Accident · No injuriesData collectionFinal reportCessna 172D · Buckland, AKThe pilot's loss of airplane control during takeoff from an off-airport site, which resulted in a runway excursion and collision with terrain.Oct 8, 2012 · N8808 · Substantial damageNTSB ERA12LA578Accident · 1 fatalLimited investigationFinal reportCessna 172B · Atlantic Ocean (Atlantic Ocean)The pilot’s suicidal act.Sep 23, 2012 · N8059X · Substantial damageNTSB CEN12CA620Accident · No injuriesData collectionFinal reportCessna 172H · Phillipsburg, OHThe pilot’s improper flare, which resulted in a hard landing.Sep 9, 2012 · N2484L · Substantial damageNTSB ERA12LA545Accident · Minor injuriesLimited investigationFinal reportCessna 172E · East Bend, NCA total loss of engine power during the initial climb after takeoff for reasons that could not be determined because examination of the engine did not reveal any anomalies that would have precluded normal operation.Sep 1, 2012 · N377SP · Substantial damageNTSB 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 WPR12CA337Accident · Minor injuriesData collectionFinal reportCessna 172 · Grand Canyon, AZThe pilot’s improper flare and inadequate recovery from a bounced landing.Jul 28, 2012 · N8100B · Substantial damageNTSB CEN12LA492Accident · No injuriesLimited investigationFinal reportMaule M-4 · Springfield, MNThe tailwheel spring's overload failure during landing, resulting in a ground loop and runway excursion.Jul 10, 2012 · N12026 · Substantial damageNTSB WPR12FA274Accident · 4 fatalField investigationFinal reportCessna 172 · Veneta, ORThe pilot’s failure to maintain adequate airspeed and altitude to clear trees during the initial climb after takeoff.Jun 23, 2012 · N5781A · Substantial damageNTSB ANC12CA054Accident · No injuriesData collectionFinal reportCessna 172 · Skwentna, AKThe improper decision of the driver of the all-terrain vehicle to enter an active runway.Jun 16, 2012 · N5874A · Substantial damageNTSB CEN12CA361Accident · No injuriesData collectionFinal reportCessna 172H · Moscow Mills, MOThe pilot's failure to maintain control of the airplane during takeoff in a gusty crosswind, which resulted in a runway excursion.Jun 10, 2012 · N3736R · Substantial damageNTSB WPR12LA253Accident · Minor injuriesLimited investigationFinal reportCessna 172B · San Andreas, CAA loss of engine power in cruise flight for reasons that could not be determined because a postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.Jun 9, 2012 · N7458X · Substantial damageNTSB WPR12LA231Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Silver City, IDThe pilot‘s failure to maintain airspeed while maneuvering in mountainous terrain with reduced visibility, which resulted in an aerodynamic stall.May 27, 2012 · N4640L · Substantial damageNTSB ERA12CA320Accident · Minor injuriesData collectionFinal reportCessna 172F · Cambridge, NYThe pilot’s loss of airplane control during a takeoff in variable crosswind conditions.May 5, 2012 · N5551R · Substantial damageNTSB WPR12LA189Accident · Serious injuriesLimited investigationFinal reportCessna 172D · Beckwourth, CAThe pilot’s failure to maintain sufficient airspeed during initial climb, which resulted in a loss of airplane control.Apr 28, 2012 · N2559U · 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 damage