Skip to content

NTSB investigations: Continental 0-300 series, TN

36 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with SQL

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 ('17022')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('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.

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 ('17022'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 ERA22LA171Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Sparta, TNMaintenance personnel’s failure to properly affix left main landing gear components, which led to the failure of the left main landing gear during the accident flight.Mar 27, 2022 · N8431U · Substantial damage NTSB ERA21LA214Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Johnson City, TNThe student pilot’s excessive airspeed during the landing approach and his delayed remedial action, which resulted in the airplane striking obstacles during an aborted landing. Contributing was the pilot’s decision to land with a tailwind.May 12, 2021 · N6344E · Substantial damage NTSB GAA16CA111Accident · No injuriesData collectionFinal reportCessna 172 · Covington, TNThe pilot's loss of directional control during the landing roll in crosswind conditions, which resulted in a runway excursion, ground loop, and impact with the ground.Nov 22, 2015 · N5786R · Substantial damage NTSB MIA08CA018Accident · No injuriesData collectionFinal reportCessna 172 · McKinnon, TNThe pilot's failure to perform a go around.Nov 18, 2007 · N5803A · Substantial damage NTSB ANC08CA017Accident · No injuriesData collectionFinal reportCessna 172 · Nashville, TNA propwash encounter during taxi from a four-engine airplane that overturned the pilot's single-engine airplane when he elected to taxi across the larger airplane's propwash.Nov 5, 2007 · N5555R · Substantial damage NTSB ATL05CA165Accident · No injuriesData collectionFinal reportCessna C172F · Sparta, TNThe pilot's delay in applying carburetor heat that resulted in the loss of engine power due to carburetor ice.Sep 30, 2005 · N8513U · Substantial damage NTSB 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 · Destroyed NTSB ATL03LA092Accident · No injuriesLimited investigationFinal reportCessna 172H · Somerville, TNThe pilot's misjudged approach airspeed and distance which resulted in an undershoot of the runway and collision with terrain.May 13, 2003 · N1748F · Substantial damage NTSB ATL02LA096Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Livingston, TNThe pilot failure to maintain flying speed, followed by a subsequent stall.May 11, 2002 · N8608B · Substantial damage NTSB ATL99LA094Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Millington, TNLoss of engine power due to undetermined reasons. Factors were weather conditions favorable to carburetor ice and the terrain condition at the forced landing site.May 20, 1999 · N5363T · Substantial damage NTSB ATL98LA120Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Sewanee, TNThe inadequate visual lookout by the ground pedestrian. A factor was dark night conditions.Aug 25, 1998 · N6720A · No damage NTSB ATL95LA137Accident · Serious injuriesLimited investigationFinal reportCessna 172D · Stanton, TNThe pilot's failure to properly plan enough fuel for the intended flight which resulted in fuel exhaustion. Factors related to the accident were: the pilot became lost/disorientated, and high vegetation in the emergency landing area.Jul 15, 1995 · N3744S · Substantial damage NTSB ATL91LA175Accident · No injuriesLimited investigationFinal reportCessna 172K · Greeneville, TNThe inadequate visual lookout by the pilot of N78239, and his failure to accurately judge the distance between the two aircraft. Factors in the accident were the dark night conditions and the resulting visual perception of aircraft lighting in dark conditions.Sep 15, 1991 · N78239 · 2 aircraft · Substantial damage NTSB ATL90LA102Accident · No injuriesLimited investigationFinal reportCessna 170 · Johnson City, TNThe pilot/mechanic's inadequate preflight inspection of the aircraft fuel system.Apr 22, 1990 · N3980V · Substantial damage NTSB ATL88LA152Accident · No injuriesLimited investigationFinal reportCessna 172F · Walland, TNThe pilot attempted to abort a takeoff after experiencing a sudden gust of wind at liftoff. The aircraft collided with a fence and ditch which caused substantial airframe damage. The pilot reported the winds gusting to 15 knots. There was no reported aircraft…Apr 22, 1988 · N1414U · Substantial damage NTSB ATL88IA113Incident · No injuriesIncident investigationFinal reportCessna 172B · Elizabethton, TNDue to a low charge in the battery, the plt elected to start the eng by hand propping, so he could program the loran for a later flt. He began hand propping with the tail & left wing tied down. After the eng started, the tiedown for the tail pulled loose &…Mar 14, 1988 · N7609X · Minor damage NTSB ATL88LA097Accident · No injuriesLimited investigationFinal reportCessna 172 · Jackson, TNWhile returning home with his newly purchased acft the plt made a refueling stop. The winds were strong and gusting upwards of thirty KTS at the refueling arpt and the destination arpt. During the takeoff roll the winds shifted to a right crosswind. The acft…Feb 22, 1988 · N6285E · Substantial damage NTSB ATL87LA266Accident · No injuriesLimited investigationFinal reportCessna 172H · Chuckey, TNThe plt estimated there was 9 gal of fuel on board when he took off. Aprx 20 min later, he was making a low pass over a private strip when the eng lost power. He stated that he repositioned the fuel selector to the other tank, but was unable to restart the…Sep 25, 1987 · N3885R · Substantial damage NTSB IAD78FA017Accident · 2 fatalClosedCessna 172H · Cades Cove, TNDec 1, 1977 · N8821Z · Destroyed NTSB IAD77DKW26Accident · No injuriesClosedCessna 172 · Beersheba Spgs, TNAug 13, 1977 · N4295F · Substantial damage NTSB MIA73DLT10Accident · No injuriesClosedCessna 172 · Stantonville, TNOct 1, 1972 · N9167B · Substantial damage NTSB MIA73DKW04Accident · No injuriesClosedCessna 172 · Clarksville, TNJul 16, 1972 · N1705F · Substantial damage NTSB MIA72FLT07Accident · Minor injuriesClosedCessna 172 · Humboldt, TNSep 5, 1971 · N5498R · Substantial damage NTSB MIA72FKW01Accident · No injuriesClosedCessna 172 · Elizabethton, TNJul 6, 1971 · N2800L · Substantial damage NTSB MIA70FKW05Accident · Serious injuriesClosedGlobe GC-1B · Vonore, TNMay 11, 1970 · N3780K · Substantial damage NTSB MIA69F0078Accident · No injuriesClosedCessna 172 · Nashville, TNAug 10, 1968 · N8254L · Substantial damage NTSB MIA68F0463Accident · No injuriesClosedCessna 172 · Knoxville, TNMar 31, 1968 · N1457F · Substantial damage NTSB MIA68D0387Accident · No injuriesClosedCessna 172 · Nashville, TNJan 29, 1968 · N4207F · Substantial damage NTSB MIA68F0196Accident · Minor injuriesClosedCessna 172E · Murfreesboro, TNSep 29, 1967 · N8693U · Substantial damage NTSB MIA67D0460Accident · No injuriesClosedCessna 172 · Sewanee, TNMar 18, 1967 · N6925X · Substantial damage NTSB MIA67D0427Accident · No injuriesClosedCessna 172 · Nashville, TNMar 4, 1967 · N4159L · Substantial damage NTSB MIA67D0403Accident · No injuriesClosedCessna 172 · Lafayette, TNFeb 13, 1967 · N3724L · Substantial damage NTSB MIA67D0086Accident · No injuriesClosedCessna 172 · Tiptonville, TNJul 30, 1966 · N3794L · Substantial damage NTSB MIA66D0496Accident · No injuriesClosedCessna 172 · Morristown, TNMar 13, 1966 · N7883U · Substantial damage NTSB UNK64X2822Accident · No injuriesClosedCessna 175A · Memphis, TNJul 14, 1964 · N7913T · Substantial damage NTSB UNK64X1071Accident · No injuriesClosedCessna 172 · Crossville, TNMar 28, 1964 · N3942S · Substantial damage