Fatal NTSB investigations: Continental 0-200 series

27 cases on aircraft whose registry engine model is Continental 0-200 series, where the first occurrence was “In flight collision with object”. 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

19822026
Fatal NTSB investigations: Continental 0-200 series per year, 1982–2026: 27 cases
19821
19833
19852
19871
19882
19891
19902
19911
19923
19962
19991
20001
20012
20021
20031
20052
20061

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 ('17020')
      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\" = 220))
  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 ATL06FA078Accident · 2 fatalField investigationFinal reportCessna 150L · Cumming, GAThe pilot's failure to consider the appropriate aircraft performance data prior to takeoff, and his improper use of the wing flaps during takeoff, which resulted in reduced climb performance and an in-flight collision with a residence. A factor associated…May 12, 2006 · N1715Q · DestroyedNTSB LAX05LA272Accident · 1 fatalLimited investigationFinal reportPatch Dan F Varieze · San Diego, CAa divergence from the final approach course and an in-flight collision with storage containers for undetermined reasons.Aug 20, 2005 · N862DP · DestroyedNTSB LAX05FA062Accident · 1 fatalField investigationFinal reportCessna 150J · Marana, AZthe failure of the pilot to maintain an adequate altitude and clearance from obstructions that resulted in an in-flight collision with power lines.Jan 8, 2005 · N51256 · Substantial damageNTSB NYC04LA011Accident · 2 fatalLimited investigationFinal reportCessna 150M · Wax, KYThe pilot's failure to maintain obstacle clearance. Low altitude flight is a contributing factor.Oct 16, 2003 · N3807V · Substantial damageNTSB LAX03FA025Accident · 1 fatalField investigationFinal reportCessna 150E · Anaheim Hills, CAthe pilot's continued VFR flight into instrument meteorological conditions and his subsequent failure to maintain clearance from power lines. A contributing factor was the pilot's impairment by medication.Nov 8, 2002 · N6236T · DestroyedNTSB IAD01FA097Accident · 2 fatalField investigationFinal reportCessna 150 · Mcgaheysville, VAThe flight instructor's failure to recover from a spin for undetermined reasons.Aug 14, 2001 · N63351 · Substantial damageNTSB NYC01FA123Accident · 2 fatalField investigationFinal reportCessna 150A · Jackson Twp., PAThe pilot's inadequate visual lookout while manuevering at low level. A factor was the pilot's improper decision to conduct low-level flight.May 13, 2001 · N7064X · Substantial damageNTSB SEA00FA133Accident · 3 fatalField investigationFinal reportCessna 150E · Ashton, IDThe pilot's failure to maintain clearance from a tree while making a low pass over an outdoor gathering of individuals. Factors include the intentional low pass, a tree located in a shadow generated by the sun's low position at dusk, hilly terrain, and the…Jul 13, 2000 · N6196T · DestroyedNTSB NYC99FA098Accident · 1 fatalField investigationFinal reportCessna 150G · Watertown, NYThe pilot-in-command misjudged altitude, which resulted in an in-flight collision with utility wires at the approach end of the airstrip. A factor was the pilot's failure to wear his corrective lenses.Apr 28, 1999 · N8426J · Substantial damageNTSB IAD96LA151Accident · 1 fatalLimited investigationFinal reportCessna 150C · Liberty, KYthe pilot's failure to maintain adequate altitude, while maneuvering at a low altitude, which resulted in in-flight collision with trees.Sep 23, 1996 · N1947Z · DestroyedNTSB IAD96LA076Accident · 2 fatalLimited investigationFinal reportCessna 150 · Welch, WVthe pilot's impairment of judgment and performance due to alcohol which led to his failure to maintain sufficient altitude to clear obstacles. A factor was his intentional buzzing.May 10, 1996 · N6303S · DestroyedNTSB NYC92FA185Accident · 1 fatalField investigationFinal reportCessna 150F · Lake Neepaulin, NJAn inflight collision with trees after the pilot failed to outclimb the terrain. Factors related to the accident were the pilot's improper use of the flaps and the pilot's decision to operate the airplane over the maximum allowable gross weight.Sep 13, 1992 · N8725G · Substantial damageNTSB SEA92FA148Accident · 1 fatalField investigationFinal reportCessna 150 · Burns, ORThe failure of the pilot to maintain clearance from wires on a 500 kv electrical power transmission line.Jul 11, 1992 · N5988E · DestroyedNTSB MIA92LA057Accident · 1 fatalLimited investigationFinal reportWalter R. Penney VARI-EZE · Lamar, MSThe pilot in commands departure into and continued flight in instrument meteorological conditions while operating under visual flight rules resulting in an inflight collision with trees and then the ground.Jan 8, 1992 · N12WP · DestroyedNTSB ATL91FA110Accident · 1 fatalField investigationFinal reportCessna 150J · Monroe, GAThe pilots attempted flight in adverse weather and the physical impairment of the student pilot from the consumption of alcoholic beverages prior to flight. A factor in the accident was the foggy weather condition at the airport.Jun 15, 1991 · N60466 · Substantial damageNTSB SEA90FA182Accident · 1 fatalField investigationFinal reportCessna 150M · Prospect, ORThe pilot's failure to maintain a proper altitude during his approach. The dark night condition was a contributing factor.Sep 14, 1990 · N3420V · DestroyedNTSB ATL90FA109Accident · 1 fatalField investigationFinal reportCessna 150L · Stockbridge, GAThe pilot's failure to maintain the proper clearance from objects on the ground.May 5, 1990 · N10790 · DestroyedNTSB MKC89FA060Accident · 1 fatalField investigationFinal reportCessna 150K · Pemberton, MNPoor judgement on the part of the pilot in that he attempted a down wind take off without adequate distance to clear obstacles in his flight path.Feb 22, 1989 · N6010G · Substantial damageNTSB SEA88LA152Accident · 1 fatalLimited investigationFinal reportCassutt III · Shelton, WAAcft had been restored and recertificated since last flight in 1969. On initial test flight takeoff, plt immediately turned to and flew low, slow landing pattern circuit with sounds of reduced power, colliding with trees in final approach turn. Investigation…Aug 13, 1988 · N2984G · DestroyedNTSB MKC88FA086Accident · 1 fatalField investigationFinal reportCessna 150F · Mansfield, MOA witness saw the acft flying at low alt as it passed in front of her car at dusk in a northeasterly drctn. She rprtd the acft contd down a valley toward power lines that spanned an open field. She saw the acft pull up rapidly, become entangled in the power…May 9, 1988 · N8605S · Substantial damageNTSB MIA88FA071Accident · 1 fatalField investigationFinal reportCessna 150H · Destin, FLWitnesses stated that they observed the acft flying in the fog in a southeasterly direction and turn hard right just before it struck the 19th floor of a condominium. The fog according to residents of the bldg was so thick that the ground could not be seen…Dec 24, 1987 · N7005S · DestroyedNTSB ATL85FA243Accident · 1 fatalField investigationFinal reportCessna 150G · Selma, ALAcft took off from sod strip on hot humid day near max weight. PIC said he used 10 degrees flaps and was airborne. At about runway mid point. When over first tree line after passing threshold acft descended. When over brown terrain acft climbed. When over…Aug 11, 1985 · N4608X · DestroyedNTSB MKC85FA069Accident · 1 fatalField investigationFinal reportCessna 150F · Waldron, MOWhile maneuvering northbound on the Missouri river levee the passenger noticed the plt flying just above the levee road. The passenger stated the plt told him they were forty feet off the ground but sometimes lower. The passenger stated he saw the pickup…Mar 9, 1985 · N8078F · DestroyedNTSB LAX83FA435Accident · 1 fatalField investigationFinal reportCassutt 3-M · Mesa, AZThe acft collided with a street lamp while pulling up from a low pass over a dry river bed. This experimental amateur built acft was operating outside the prescribed boundaries for this acft. Witnesses disagreed on the engine sounds. Somedescribed the engine…Sep 10, 1983 · N2309E · DestroyedNTSB MIA83FA173Accident · 1 fatalField investigationFinal reportTaylorcraft TC-19 · Lorida, FLWitnesses along a highway observed the acft flying at low altitude. One witness saw the acft hit a powerline, climb a little, then crash nose first.Jul 1, 1983 · N20021 · DestroyedNTSB SEA83FA062Accident · 1 fatalField investigationFinal reportCessna 150J · Glenns Ferry, IDThe acft collided with wires and crashed during a low pass while it was being delivered to a repair station. The pilot was flying low to keep pace with his wife who was following in a car to transport the pilot after landing. Witnesses observed the acft…Mar 13, 1983 · N60461 · DestroyedNTSB SEA82FA064Accident · 2 fatalField investigationFinal reportCessna 150H · Oregon City, ORThe aircraft crashed during takeoff from a private airport that was not open to the public. Operations on the airport were at the owner's discretion (prior permission required). An electric fence crossed the airport about 1500 ft from the south end. The owner…May 4, 1982 · N6752S · Destroyed