NTSB investigations: Continental 0-300 series, 2011

17 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
NTSB investigations: Continental 0-300 series, 2011 per year, 1964–2026: 3,125 cases
1964183
1965197
1966237
1967250
1968163
1969112
1970114
1971113
197296
197387
197453
197551
197661
197768
197865
197949
198037
198148
198231
198331
198434
198531
198638
198739
198835
198927
199028
199123
199229
199330
199422
199532
199629
199718
199831
199928
200027
200128
200230
200337
200428
200532
200627
200728
200823
200918
201022
201117
201220
201321
201412
201522
201617
201720
201822
201923
202013
202130
202217
202319
202417
202525
202610

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\") = 2011
    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 ERA12LA101Accident · No injuriesLimited investigationFinal reportCessna 172D · Belhaven, NCA total loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.Dec 4, 2011 · N2344U · Substantial damageNTSB ERA12CA053Accident · Serious injuriesData collectionFinal reportCessna 172F · Smoketown, PAThe pilot did not maintain a proper approach path, which resulted in a collision with a tree.Oct 28, 2011 · N5613R · Substantial damageNTSB ERA12CA036Accident · Serious injuriesData collectionFinal reportCessna 172F · Atlanta, GAThe pilot's inadequate preflight planning, which resulted in a total loss of engine power due to fuel exhaustion.Oct 17, 2011 · N5419R · Substantial damageNTSB WPR11CA413Accident · Minor injuriesData collectionFinal reportCessna 172F · Atlanta, IDThe pilot’s misjudgment of his final approach path. Contributing to the accident was the pilot’s inadequate preflight planning.Aug 29, 2011 · N8698U · Substantial damageNTSB ERA11CA331Accident · Serious injuriesData collectionFinal reportCessna 172 · Ghent, NYThe pilot's delayed decision to abort the landing and execute a go-around.Jun 8, 2011 · N8895B · Substantial damageNTSB CEN11LA388Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Ironton, OHThe total loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.May 28, 2011 · N5663R · Substantial damageNTSB WPR11CA489Accident · No injuriesData collectionFinal reportCessna 172C · Grants Pass, ORThe student pilot's failure to maintain an adequate airspeed on approach, which resulted in a hard landing.May 7, 2011 · N8287X · Substantial damageNTSB WPR11LA211Accident · No injuriesLimited investigationFinal reportCessna 172 · Mesa, AZThe student pilot's inadequate directional control during the landing roll.Apr 27, 2011 · N4072F · Substantial damageNTSB CEN11CA293Accident · No injuriesData collectionFinal reportCessna 172 · Greenville, TXThe pilot's delayed action in performing a go-around maneuver, which resulted in an impact with trees.Apr 16, 2011 · N6933A · 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 ERA11LA156Accident · No injuriesLimited investigationFinal reportCessna 172G · Clarksville, FLA loss of engine power due to fuel starvation as a result of the owner's improper maintenance of the fuel selector valve, which resulted in a lack of fuel supply from the right fuel tank.Feb 23, 2011 · N3740L · Substantial damageNTSB WPR11LA135Accident · No injuriesLimited investigationFinal reportCessna 172H · Wikieup, AZA total loss of engine power during cruise flight resulting from the failure of a fuel line. Contributing to the accident was inadequate maintenance inspections that failed to detect the deteriorating fuel line.Feb 15, 2011 · N2561L · Substantial damageNTSB ERA11CA144Accident · No injuriesData collectionFinal reportCessna 172H · Plattsburgh, NYThe student pilot's loss of directional control during the landing flare in gusting wind conditions and the certified flight instructor's delayed remedial action.Feb 14, 2011 · N2593L · Substantial damageNTSB WPR11CA152Accident · No injuriesData collectionFinal reportCessna 172 · Lancaster, CAThe student pilot's improper flare which resulted in a hard landing. Contributing to the accident was the certified flight instructor's delayed remedial action.Feb 13, 2011 · N31FC · Substantial damageNTSB WPR11FA117Accident · Serious injuriesField investigationFinal reportCessna 172 · Glendora, CAThe flight crew's failure to maintain adequate terrain clearance while maneuvering in downdraft conditions over mountains.Jan 31, 2011 · N6922A · Substantial damageNTSB CEN11LA153Accident · Serious injuriesLimited investigationFinal reportCessna 172A · Clarendon, TXThe pilot's failure to correctly set the altimeter, which resulted in his erroneous perception that the airplane was at a safe altitude.Jan 17, 2011 · N7262T · Substantial damageNTSB CEN11LA138Accident · 1 fatalLimited investigationFinal reportCessna 172H · Walnut Grove, MOThe pilot's loss of control for undetermined reasons. Contributing to the accident was the pilot's fatigue.Jan 4, 2011 · N1416F · Substantial damage