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
| 1982 | 1 |
|---|---|
| 1983 | 3 |
| 1985 | 2 |
| 1987 | 1 |
| 1988 | 2 |
| 1989 | 1 |
| 1990 | 2 |
| 1991 | 1 |
| 1992 | 3 |
| 1996 | 2 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 2 |
| 2002 | 1 |
| 2003 | 1 |
| 2005 | 2 |
| 2006 | 1 |
Where
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.
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" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
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…NTSB 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.NTSB 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.NTSB NYC04LA011Accident · 2 fatalLimited investigationFinal reportCessna 150M · Wax, KYThe pilot's failure to maintain obstacle clearance. Low altitude flight is a contributing factor.NTSB 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.NTSB IAD01FA097Accident · 2 fatalField investigationFinal reportCessna 150 · Mcgaheysville, VAThe flight instructor's failure to recover from a spin for undetermined reasons.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB ATL90FA109Accident · 1 fatalField investigationFinal reportCessna 150L · Stockbridge, GAThe pilot's failure to maintain the proper clearance from objects on the ground.NTSB 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.NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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.NTSB 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…NTSB 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…