NTSB investigations: Continental 0-200 series, TN
94 cases on aircraft whose registry engine model is Continental 0-200 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
| 1964 | 3 |
|---|---|
| 1965 | 1 |
| 1966 | 2 |
| 1967 | 3 |
| 1968 | 4 |
| 1969 | 7 |
| 1970 | 6 |
| 1971 | 4 |
| 1972 | 4 |
| 1973 | 3 |
| 1974 | 2 |
| 1975 | 6 |
| 1976 | 3 |
| 1977 | 4 |
| 1978 | 2 |
| 1979 | 3 |
| 1981 | 3 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 2 |
| 1988 | 2 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1995 | 1 |
| 1996 | 3 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 2 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2007 | 1 |
| 2010 | 3 |
| 2011 | 3 |
| 2019 | 1 |
| 2022 | 1 |
| 2024 | 3 |
Where
Open the mapLatest 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.\"eventStateOrRegion\" = 'TN' AND c.\"eventCountry\" = 'USA'
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'))
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."eventStateOrRegion" = 'TN' AND c."eventCountry" = 'USA'
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'))
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 ERA25FA037Accident · 1 fatalClass 3 · FieldFinal reportCessna 150F · Wilder, TNThe student pilot’s decision to continue the visual flight rules flight into instrument meteorological conditions at night, which resulted in controlled flight into terrain.NTSB ERA24LA234Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Fayetteville, TNA collision with a deer during the takeoff roll.NTSB ERA24LA087Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Hohenwald, TNThe pilot’s failure to use carburetor heat in conditions conducive to the formation of carburetor ice, which resulted in a partial loss of engine power due to fuel starvation. Contributing to the outcome was her failure to attain a proper touchdown point…NTSB ERA22LA103Accident · No injuriesClass 4 · LimitedFinal reportCessna 150G · Knoxville, TNThe pilot of the Cessna 150’s failure to avoid the taxiing Cessna 172.NTSB GAA19CA543Accident · No injuriesData collectionFinal reportCessna 150 · Memphis, TNThe student pilot's improper landing flare and the flight instructor's delayed remedial action during landing, which resulted in a loss of airplane control and impact with terrain.NTSB ERA12CA125Accident · Serious injuriesData collectionFinal reportCessna 150H · Knoxville, TNThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA11LA203Accident · No injuriesLimited investigationFinal reportCessna 150H · Maury City, TNThe pilot's failure to attain the proper glidepath during on off-airport landing.NTSB ERA11LA149Accident · No injuriesLimited investigationFinal reportCessna 150H · Jonesborough, TNA partial loss of engine power during initial climb for undetermined reasons.NTSB ERA10FA503Accident · 1 fatalField investigationFinal reportCessna 150F · Sweetwater, TNThe pilot's inadequate preflight weather planning and improper decision to continue a visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and a loss of control.NTSB ERA10CA372Accident · No injuriesData collectionFinal reportCessna 150M · Knoxville, TNThe student pilot's improper recovery from a bounced landing.NTSB ERA10CA324Accident · No injuriesData collectionFinal reportCessna 150G · Jasper, TNThe pilot under instruction's failure to maintain directional control during landing, and his failure to relinquish the flight controls when directed.NTSB ATL07CA071Accident · No injuriesData collectionFinal reportCessna C-150H · Dyersburg, TNThe student's pilot's misjudged distance/altitude that led to an undershoot and a failure to attain the proper touchdown point.NTSB ATL05CA095Accident · Minor injuriesData collectionFinal reportDavid S Robbins Christavia MK 1 · Decherd, TNThe pilot's inadequate preflight planning which resulted in fuel exhaustion and subsequent loss of engine power.NTSB ATL04CA197Accident · No injuriesData collectionFinal reportCessna 150M · Sevierville, TNThe pilot's failure to maintain directional control during an attempted takeoff, which resulted in the on ground collision with high vegetation and a subsequent nose over. Factors were a foggy windshield and windshield defrost not activated.NTSB ATL03LA083Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Trenton, TNThe pilot's loss of control in flight and failure to maintain adequate airspeed which resulted in a stall, and subsequent collision with the ground.NTSB MIA02LA124Accident · No injuriesLimited investigationFinal reportMckean Varieze · Covington, TNThe pilot's improper planned approach following loss of engine power due to fuel starvation resulting in damage to the airplane during an off-airport landing. Contributing to the accident was the pilot's lack of familiarity with the accident airplane.NTSB ATL01FA059Accident · 1 fatalField investigationFinal reportCessna 150 G · Dunlap, TNThe pilot's failure to maintain flying speed that resulted in a stall and subsequent loss of control in flight.NTSB ATL01LA052Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Maryville, TNThe pilot's inadequate preflight planning that resulted in the in-flight collision with a fence during an attempted takeoff from a grass strip.NTSB MIA00LA100Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Dandridge, TNthe student pilot's improper preflight that resulted in his operating an aircraft with contaminated fuel that resulted in a loss of engine power and a forced landing in the trees and damage to the aircraft. Contributing to the accident were the student's…NTSB MIA00LA037Accident · No injuriesLimited investigationFinal reportCessna 150M · Morristown, TNThe pilot's failure to maintain directional control during the takeoff phase of a touch and go landing, and the subsequent skid off the runway and collapsed nose landing gear during the attempt to abort the takeoff.NTSB MIA97LA037Accident · No injuriesLimited investigationFinal reportCessna 150M · Knoxville, TNthe student pilot's improper planning/decision, and his failure to maintain proper runway alignment during a crosswind landing. The strong crosswind was a related factor.NTSB ATL96LA055Accident · No injuriesLimited investigationFinal reportCessna 152 · Arlington, TNthe failure of the pilot of the Cessna 150, N63434, to see and avoid the Cessna 152, N151FC.NTSB ATL96LA040Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Knoxville, TNFailure of the pilot to maintain sufficient airspeed during a go-around, which resulted in a stall.NTSB ATL95LA051Accident · No injuriesLimited investigationFinal reportTaylorcraft F19 · Tullahoma, TNA lack of lubricant to the starter/roller clutch, seizure of the starter, and failure of the four crankshaft gear capscrews (bolts), which resulted in disengagement of the crankshaft (accessory) gear and subsequent loss of engine power.NTSB ATL93LA017Accident · No injuriesLimited investigationFinal reportCessna 150 · Powell, TNThe water in the aircraft fuel as a result of the improper preflight by the pilot.NTSB ATL91LA087Accident · No injuriesLimited investigationFinal reportCessna 150 · Copperhill, TNThe pilot's improper use of carburetor heat. A factor in the accident was the existing of carburetor icing conditions.NTSB ATL90LA137Accident · No injuriesLimited investigationFinal reportCessna 150L · Blountville, TNThe pilot's inaccurate fuel consumption calculations which resulted in fuel exhaustion.NTSB ATL89LA162Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Knoxville, TNThe pilot's failure to recognize that the engine was not developing full power and the delay in performing remedial action until it was too late to stop the airplane on the runway.NTSB ATL89LA003Accident · No injuriesLimited investigationFinal reportCessna 150M · Silerton, TNThe student plt was on a VFR x-country flt. She rprtd that after leveling at 2000', the eng began running rough & the RPM dropped from 2400 to about 2000 RPM. The acft would not maint alt. The student said she applied carb heat when the acft was at about…NTSB ATL88FA106Accident · 2 fatalField investigationFinal reportCessna 150 · Knoxville, TNThe Cessna made a long straight in final approach. The aircraft's radio transmitter was inop. Afterward the Cessna PIC rpted that initially he saw the Beech on a left base. Later he stated the Beech was heading away from the traffic pattern. Witnesses…NTSB ATL88LA063Accident · No injuriesLimited investigationFinal reportCessna 150K · Portland, TNThe student plt rptd that the airplane veered off the rt side of the rwy into a ditch while ldg in x-wind conditions. The student plt estimated that the wind velocity was 10 KTS with gusts to 20 KTS. The student rptdly had about 32 hrs total flt experience,…NTSB ATL88LA022Accident · Serious injuriesLimited investigationFinal reportCessna 150C · Wartburg, TNThe aircraft touched down hard on the 1300 foot grass strip and began to porpoise. The pilot attempted to go-around but was unable to gain sufficient altitude to avoid striking a power line. The plt did not file an acc report.NTSB ATL86LA095Accident · No injuriesLimited investigationFinal reportCessna 150 · Lafayette, TNThe pilot stated that he had completed a touchdown and was on rollout when he noticed a deer on the runway. He increased the power enough to avoid colliding with the deer, but stalled the aircraft and collided with the runway surface failing the nose gear.…NTSB ATL85LA088Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Hartford, TNThe plt was informed during wx briefing that VFR was not recommended because of low clouds. Plt elected to takeoff and follow I-90, however, wx conditions were poor and plt executed a climb to 10000 ft to clear the cloud layer. While en route the plt tuned to…NTSB ATL81FLT13Accident · Serious injuriesClosedCessna 150 · Jackson, TNNTSB ATL81FLT09Accident · Minor injuriesClosedCessna 150 · Bolivar, TNNTSB ATL81FKW12Accident · No injuriesClosedCessna 150F · Lebanon, TNNTSB IAD79FKW10Accident · Minor injuriesClosedTaylorcraft F-19 · Elk Valley, TNNTSB IAF79FLT04Accident · No injuriesClosedCessna 150 · Memphis, TNNTSB IAD79FKW06Accident · 2 fatalClosedCessna 150F · Bristol, TNNTSB IAD79FA021Accident · 1 fatalClosedCessna 150L · Bolivar, TNNTSB IAD79FLT01Accident · No injuriesClosedCessna 150 · Covington, TNNTSB IAD78FA024Accident · Minor injuriesClosedCessna 150 · Arlington, TNNTSB IAD78DKW03Accident · No injuriesClosedCessna 150 · Johnson City, TNNTSB IAD77DKW23Accident · No injuriesClosedCessna 150 · Celina, TNNTSB IAD77FKW15Accident · No injuriesClosedCessna 150 · Gallatin, TNNTSB IAD76DKW36Accident · No injuriesClosedCessna 150 · Lawrenceburg, TNNTSB IAD76FKW34Accident · Serious injuriesClosedCessna 150 · Murfreesboro, TNNTSB IAD76FLT08Accident · No injuriesClosedCessna 150 · Covington, TNNTSB IAD76FKW18Accident · No injuriesClosedCessna 150 · Knoxville, TN