Skip to content

NTSB investigations: Continental 0-300 series, NM

54 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

NTSB investigations: Continental 0-300 series, NM per year, 1964–2026: 54 cases
1964	4
1965	2
1966	5
1967	3
1968	6
1969	3
1970	4
1971	1
1972	1
1973	4
1974	1
1976	1
1977	2
1981	2
1982	1
1985	1
1986	3
1992	1
1997	1
2001	1
2002	2
2008	1
2010	1
2018	1
2021	2

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" = 'NM' 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\" = 'NM' 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" = 'NM' 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 WPR22LA038Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Belen, NMThe pilot’s failure to maintain directional control during takeoff.Nov 15, 2021 · N3463C · Substantial damage NTSB WPR21LA180Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Cuba, NMThe pilot's failure to maintain lateral control during takeoff after an encounter with a gusting wind, which resulted in a wing strike.May 2, 2021 · N9127B · Substantial damage NTSB GAA18CA493Accident · Minor injuriesData collectionFinal reportCessna 172 · Silver City, NMThe pilot’s failure to maintain directional control while landing with a quartering tailwind.Aug 15, 2018 · N1543Y · Substantial damage NTSB CEN10LA282Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Las Cruces, NMA loss of engine power due to fuel starvation as a result of water contamination in the fuel, and the pilot's inadequate preflight inspection. Contributing the accident was an inoperative number 5 cylinder exhaust valve.May 30, 2010 · N2723U · Destroyed NTSB DFW08LA217AccidentLimited investigationFinal reportCessna 172A · Albuquerque, NMThe pilot's failure to maintain proper glide angle during the landing approach which resulted in a collision with a pole. Contributing to the accident were the pilot's lack of qualification, experience and the high density altitude.Aug 28, 2008 · N6539B · Substantial damage NTSB FTW02LA170Accident · No injuriesLimited investigationFinal reportCessna 172E · Navajo Dam, NMthe pilot's failure maintain directional control of the airplane during a touch and go landing which resulted in a collision with trees. A contributing factor was the gusting wind conditions.Jun 2, 2002 · N364SR · Substantial damage NTSB FTW02LA084Accident · No injuriesLimited investigationFinal reportCessna 172A · Albuquerque, NMthe pilot's delay in executing a go-around while conducting a simulated emergency landing, which resulted in an in flight collision with terrain.Feb 22, 2002 · N6845X · Substantial damage NTSB FTW01LA075Accident · No injuriesLimited investigationFinal reportCessna 172F · Clovis, NMthe pilot's failure to maintain directional control during take off roll resulting in a ground loop. A contributing factor was the crosswind.Mar 6, 2001 · N5175F · Substantial damage NTSB FTW98LA036Accident · No injuriesLimited investigationFinal reportCessna 172F · Hurley, NMthe student pilot's failure to adequately compensate for the wind conditions. Factors included the gusty crosswind conditions and inadequate supervision of the student pilot's solo flight by his flight instructor.Oct 29, 1997 · N8714U · Substantial damage NTSB DEN92LA087Accident · No injuriesLimited investigationFinal reportCessna 172F · Folsom, NMCarburetor heat not used and improper use of throttle and mixture control. A factor was: the lack of suitable terrain for a forced landing.Aug 25, 1992 · N5101F · Substantial damage NTSB DEN87FA039Accident · 1 fatalField investigationFinal reportCessna 172E · Crossroads, NMThe student plt with no simulated or actual instrument and a total of 9 hours night flt time called the amarillo FAA fss, who briefed him on wx for a flt from borger, Texas, to big spring, Texas, located 210 NM south. He was briefed on marginal VFR wx en…Dec 21, 1986 · N7821U · Destroyed NTSB DEN86LA214Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Albuquerque, NMWhile taxiing for takeoff in strong gusty wind conditions the aircraft was blown into an inverted position on the taxiway.Jul 31, 1986 · N3809R · Substantial damage NTSB DEN86LA117Accident · No injuriesLimited investigationFinal reportCessna 172H · Crossroads, NMAccording to the plt, he was attempting to underfly powerlines over a public road during landing, when the aircraft contacted an unseen wire and crashed.Apr 14, 1986 · N2896L · Substantial damage NTSB DEN86LA053Accident · No injuriesLimited investigationFinal reportCessna 172A · Anthony, NMThe plt was practicing emer ldgs on a dirt road. During the last ldg which resulted in an accident, he allowed his attention to be diverted momentarily to inside the cockpit and he lost control of the acft. The acft veered off the roadand sustained…Dec 22, 1985 · N7451T · Substantial damage NTSB FTW82DA122Accident · No injuriesFinal reportCessna 172 · Gallup, NMOn the second landing of the flight the aircraft veered to the left and departed the runway. The aircraft nosed over after hitting soft dirt and a drainage ditch. The pilot stated that the aircraft swerved on the first landing and he felt that the passenger…Apr 11, 1982 · N8408U · Substantial damage NTSB FTW81FA113Accident · 3 fatalClosedCessna 172D · Alamogordo, NMJul 1, 1981 · N2591Y · Destroyed NTSB FTW81DQA33Accident · Minor injuriesClosedCessna 172 · Luna, NMJun 6, 1981 · N3574S · Destroyed NTSB DEN77FQA55Accident · Minor injuriesClosedCessna 172 · Albuquerque, NMSep 12, 1977 · N1175F · Substantial damage NTSB DEN77DQA11Accident · No injuriesClosedCessna 172 · Lordsburg, NMFeb 18, 1977 · N5733R · Substantial damage NTSB DEN76FQA59Accident · Minor injuriesClosedCessna 172 · Albuquerque, NMAug 7, 1976 · N8031L · Substantial damage NTSB DEN75AQA02Accident · Minor injuriesClosedCessna 172G · Wagon Mound, NMJul 8, 1974 · N3735L · Substantial damage NTSB DEN73DQA41Accident · No injuriesClosedCessna 170 · Los Alamos, NMMay 16, 1973 · N3947V · Substantial damage NTSB DEN73DQD15Accident · No injuriesClosedCessna 172D · Animas, NMApr 9, 1973 · N2154Y · Substantial damage NTSB DEN73FQA27Accident · No injuriesClosedCessna 172G · Moriarty, NMFeb 17, 1973 · N4226L · Substantial damage NTSB DEN73DQA24Accident · No injuriesClosedCessna 172 · Tanner, NMJan 21, 1973 · N3931F · Substantial damage NTSB DEN72DQG32Accident · No injuriesClosedCessna 172 · Clovis, NMMar 20, 1972 · N5668A · Substantial damage NTSB DEN71FQA47Accident · Minor injuriesClosedCessna 172G · Albuquerque, NMFeb 27, 1971 · N4162L · Destroyed NTSB DEN71FQD06Accident · Minor injuriesClosedCessna 172 · Sunspot, NMAug 30, 1970 · N3917L · Substantial damage NTSB DEN71DQA05Accident · No injuriesClosedCessna 172 · El Rito, NMAug 22, 1970 · N4183F · Substantial damage NTSB DEN70FQD03Accident · Minor injuriesClosedCessna 172H · Tyrone, NMFeb 1, 1970 · N3777F · Substantial damage NTSB DEN70DQA02Accident · No injuriesClosedCessna 172 · Los Alamos, NMJan 15, 1970 · N5347R · Substantial damage NTSB DEN70D0153Accident · No injuriesClosedCessna 172 · Gallup, NMDec 13, 1969 · N3826L · No damage NTSB DEN70D0152Accident · No injuriesClosedCessna 172 · Moriarty, NMDec 12, 1969 · N8292X · Substantial damage NTSB DEN69F0230Accident · No injuriesClosedCessna 172G · Albuquerque, NMMay 9, 1969 · N4110L · Substantial damage NTSB DEN69A0031Accident · 1 fatalClosedCessna 172 · Sandia Park, NMDec 26, 1968 · N9200V · Destroyed NTSB DEN69D0127Accident · No injuriesClosedCessna 170B · Whites City, NMOct 14, 1968 · N2953D · Substantial damage NTSB DEN69F0090Accident · No injuriesClosedCessna 172 · Lordsburg, NMAug 30, 1968 · N6724A · Substantial damage NTSB DEN68F0240Accident · No injuriesClosedCessna 172 · Mountainair, NMMar 9, 1968 · N7069T · Substantial damage NTSB DEN68D0227Accident · No injuriesClosedCessna 172 · Columbus, NMMar 8, 1968 · N3717F · Substantial damage NTSB DEN68A0032Accident · No injuriesClosedCessna 172 · Mountainair, NMJan 23, 1968 · N3662L · Substantial damage NTSB DEN68D0116Accident · No injuriesClosedCessna 172 · Gallup, NMOct 17, 1967 · N8014L · Substantial damage NTSB DEN68D0078Accident · No injuriesClosedCessna 172 · Cowles, NMJul 5, 1967 · N5062A · Substantial damage NTSB DEN68D0020Accident · No injuriesClosedCessna 170 · Mountainair, NMJun 17, 1967 · N5724C · Substantial damage NTSB DEN67F0081Accident · No injuriesClosedCessna 172 · Roswell, NMSep 3, 1966 · N4398L · Substantial damage NTSB DEN67D0047Accident · No injuriesClosedCessna 172 · Quemado, NMJul 23, 1966 · N8182B · Destroyed NTSB DEN67D0027Accident · Minor injuriesClosedCessna 172G · Albuquerque, NMJun 28, 1966 · N5932R · Destroyed NTSB DEN67D0001Accident · No injuriesClosedCessna 170 · Deming, NMMay 31, 1966 · N4302B · Substantial damage NTSB DEN66D0238Accident · No injuriesClosedCessna 172 · Zuni, NMFeb 26, 1966 · N3789L · Substantial damage NTSB DEN66D0011Accident · No injuriesClosedCessna 172 · Albuquerque, NMJun 11, 1965 · N8333B · Substantial damage NTSB DEN65F0111Accident · No injuriesClosedCessna 172 · Albuquerque, NMMay 29, 1965 · N6668A · Substantial damage