Fatal NTSB investigations: Continental 0-300 series

25 cases on aircraft whose registry engine model is Continental 0-300 series, where the first occurrence was “Loss of control - in flight”. 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

19832026
Fatal NTSB investigations: Continental 0-300 series per year, 1983–2026: 25 cases
19832
19852
19871
19892
19921
19932
19962
19991
20001
20013
20021
20031
20041
20052
20062
20071

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.\"highestInjuryLevel\" = 'Fatal'
    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\" = 250))
  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 CHI07FA290Accident · 2 fatalField investigationFinal reportCessna 172C · Kelleys Island, OHThe pilot's failure to maintain control of the airplane due to spatial disorientation. Contributing to the accident were the water and dark night conditions which resulted in the lack of ground references during the takeoff.Sep 4, 2007 · N1301Y · Substantial damageNTSB NYC07LA011Accident · 1 fatalLimited investigationFinal reportBishop Bakeng Duce · South Boston, VAThe pilot's failure to maintain airspeed during a go-around, which resulted in an inadvertent stall. Contributing was the deteriorating weather and diminishing light conditions, the pilot's decision to take off despite the weather advisory, and the pilot's…Oct 22, 2006 · N91BK · Substantial damageNTSB CHI06LA070Accident · 1 fatalLimited investigationFinal reportCessna 172 · Harrison, MIThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. A factor associated with the accident was the pilot's impairment due to drugs.Jan 22, 2006 · N8540B · Substantial damageNTSB LAX05LA286Accident · 1 fatalLimited investigationFinal reportCessna 172 · Yuma, AZthe pilot's failure to maintain an adequate airspeed on short final, which resulted in an inadvertent stall.Sep 2, 2005 · N5070A · DestroyedNTSB SEA05FA180Accident · 1 fatalField investigationFinal reportMaule Bee Dee M-4 · Ritter, ORThe loss of control for an undetermined reason which resulted in a ground collision.Aug 24, 2005 · N11WG · DestroyedNTSB ATL04FA130Accident · 2 fatalField investigationFinal reportCessna 172F · Madisonville, TNThe pilot's failure to maintain airspeed while maneuvering on a touch and go landing resulting in a stall and collision with the ground.Jun 12, 2004 · N8777U · DestroyedNTSB CHI03LA216Accident · 1 fatalLimited investigationFinal reportCessna 172H · Isle, MNThe pilot's failure to maintain adequate airspeed which resulted in a stall. The trees, high density altitude, and the soft field were additional factors.Jul 18, 2003 · N1606F · DestroyedNTSB ATL02FA121Accident · 1 fatalField investigationFinal reportCessna 172H · Palmetto, FLThe pilot's failure to maintain airspeed which resulted in a stall while maneuvering after a banner release.Jun 6, 2002 · N260WB · DestroyedNTSB NYC02FA012Accident · 3 fatalField investigationFinal reportCessna 172 · South Hero, VTThe pilot's failure to maintain aircraft control during the takeoff. Factors in this accident were wind gusts and the airplane's high gross weight condition.Oct 18, 2001 · N8255B · DestroyedNTSB NYC01FA147Accident · 1 fatalField investigationFinal reportCessna 172 · Newfane, VTThe pilot's failure to maintain aircraft control during takeoff. A factor was the pilot's impairment due to a narcotic painkiller and antihistamine.Jun 16, 2001 · N7106T · Substantial damageNTSB LAX01FA070Accident · 2 fatalField investigationFinal reportCessna 172F · San Luis Obispo, CAThe pilot's failure to maintain a proper climb rate to VFR conditions on-top.Jan 7, 2001 · N383CA · DestroyedNTSB NYC00FA226Accident · 1 fatalField investigationFinal reportCessna 172 · Davis, WVThe pilot-in-command's inadequate weather evaluation, which resulted in a takeoff with a tailwind, and a subsequent inadvertent stall. Factors were a high gross weight, a high density altitude, and a tailwind.Aug 12, 2000 · N8874B · Substantial damageNTSB ANC99FA128Accident · 2 fatalField investigationFinal reportCessna 170B · Cooper Landing, AKThe pilot's inadvertent stall.Aug 29, 1999 · N3402D · DestroyedNTSB IAD97LA009Accident · 1 fatalLimited investigationFinal reportCessna 172A · Lebanon, OHimproper aircraft handling by the tow pilot and/or the glider pilots, which allowed the tow plane and glider to get out of position with one another; and failure of the aircrews (in both aircraft) to ensure a timely release of the glider tow rope.Oct 20, 1996 · N9890T · DestroyedNTSB IAD96FA057Accident · 3 fatalField investigationFinal reportCessna 172 · Barkhamsted, CTthe CFI pilot/passenger's poor judgment which led to spatial disorientation and subsequent loss of control of the airplane. Factors involved in this accident were the night marginal visual flight conditions and continuing flight with a known nonfunctioning…Apr 6, 1996 · N6234E · DestroyedNTSB MIA93FA194Accident · 1 fatalField investigationFinal reportCessna 172H · Liberty, MSThe pilot's delayed go-around and failure to retract the flaps in a timely manner. Factors which contributed to the accident were: the pilot's misjudgment of distance and speed which resulted in overshooting the approach, and the existence of power lines…Sep 12, 1993 · N3767R · DestroyedNTSB ATL93FA059Accident · 3 fatalField investigationFinal reportCessna 172G · Jackson, GAThe pilots inadequate preflight planning and his failure to properly compensate for the wind. A factor was the unfavorable wind condition at the time of take off.Mar 7, 1993 · N5972R · Substantial damageNTSB ATL92FA108Accident · 3 fatalField investigationFinal reportCessna 172B · Cherokee, NCThe failure of the pilot to maintain control of the aircraft as a result of spatial disorientation. The lack of total flight time, and rain in the accident area were factors in the accident.May 24, 1992 · N8102X · DestroyedNTSB LAX90FA025Accident · 2 fatalField investigationFinal reportCessna 172 · Safford, AZThe pilot failed to maintain an airspeed above the aircraft's stall speed as he turned away from ascending terrain. The aircraft's inadequate performance resulting from improper grade of fuel and high density altitude and the pilot's lack of experience in…Nov 6, 1989 · N5624A · Substantial damageNTSB LAX89LA262Accident · 1 fatalLimited investigationFinal reportCessna 172H · Dana Point, CAPilot-in-commands failure to maintain control of the airplane while in maneuvering flight.Aug 6, 1989 · N2667L · DestroyedNTSB SEA87FA152Accident · 4 fatalField investigationFinal reportCessna 172 · Pahrump, NVThe pilot entered a box canyon and attempted to either outclimb the terrain or reverse course. The aircraft's airspeed was allowed to decrease below vs and the aircraft stalled. A density altitude of approximately 9500 feet existed at the time. Insufficient…Aug 2, 1987 · N8696B · DestroyedNTSB ATL86FA001Accident · 2 fatalField investigationFinal reportCessna 172 · Chapel Hill, NCN2765U crashed shortly after making a low pass over a private air strip near Chapel Hill. The aircraft was seen in a nose high attitude prior to impacting a tree about 40 above the ground. The aircraft also collided with a power transmission line. The…Oct 1, 1985 · N2765U · DestroyedNTSB ATL85FA237Accident · 1 fatalField investigationFinal reportCessna 172A · Glencoe, KYThe acft crashed in a field next to where a friend of the plt was baling hay. The plt had called the friend earlier in the day & ask the friend to go fly with him. Just prior to the acdnt, the plt flew over & circled a couple of times at low alt. Two…Aug 5, 1985 · N7279T · Substantial damageNTSB FTW83FA441Accident · 3 fatalField investigationFinal reportCessna 172E · Leesville, LAEarlier in the day the four occupants of the acft had been reported to the sheriff's dept as being drunk at a lounge near zwolle,LA. After landing at the Leesville arpt the acft ran off the asphalt bending both ends of the prop blades. The occupants attempted…Sep 27, 1983 · N3058U · DestroyedNTSB FTW83FA362Accident · 3 fatalField investigationFinal reportCessna 172F · El Paso, TXTwo plts & 2 passengers departed san angelo, TX, on a x-country flt, one of the plts, who had 95 hrs of flying time, was the pilot-in-command (PIC) for the 1st leg of the x-country to El Paso, TX. On the next leg, the other plt assumed duties as PIC & signed…Aug 7, 1983 · N5259F · Destroyed