NTSB investigations: Continental 0-200 series, NM
85 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 | 2 |
|---|---|
| 1965 | 3 |
| 1966 | 5 |
| 1967 | 5 |
| 1968 | 5 |
| 1969 | 6 |
| 1970 | 9 |
| 1971 | 1 |
| 1972 | 3 |
| 1973 | 3 |
| 1974 | 3 |
| 1975 | 4 |
| 1976 | 3 |
| 1977 | 5 |
| 1978 | 3 |
| 1979 | 2 |
| 1980 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 1997 | 2 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2002 | 2 |
| 2003 | 1 |
| 2013 | 1 |
| 2016 | 1 |
| 2026 | 2 |
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\" = '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 ('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" = '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 ('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 WPR26LA325Accident · No injuriesClass 4 · LimitedInvestigation openCessna 150 · Socorro, NMNTSB WPR26LA168Accident · No injuriesClass 4 · LimitedFinal reportCessna 150H · Española, NMThe pilot’s loss of of directional control during landing roll following an encounter with a dust devil.NTSB GAA16CA267Accident · Minor injuriesData collectionFinal reportCessna 150 · Albuquerque, NMThe student pilot's inadequate preflight inspection/planning, which resulted in fuel exhaustion, loss of engine power, and impact with terrain.NTSB CEN13LA179Accident · 1 fatalLimited investigationFinal reportCessna 150M · Deming, NMThe pilot's physical incapacitation, including loss of vision, which led to a loss of control and the subsequent in-flight breakup of the airplane.NTSB DEN03LA149Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Farmington, NMthe pilot's improper procedures/directives, and the delayed activation of carburetor heat which resulted in the loss of engine power and subsequent impact with terrain. Contributing factors include the carburetor icing conditions, and the rough/uneven and…NTSB FTW02LA248Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Deming, NMThe loss of engine power due to carburetor ice as a result of the pilot's failure to apply carburetor heat. A contributing factor was the weather conducive to carburetor icing conditions.NTSB DEN02LA079Accident · No injuriesLimited investigationFinal reportCessna 150F · Grants, NMthe pilot's inadequate preflight preparation, and his failure to maintain airspeed which resulted in an inadvertent stall. Contributing factors were the high density altitude conditions, the terrain barrier (berm).NTSB DEN00LA130Accident · No injuriesLimited investigationFinal reportCessna 150L · Reserve, NMSeizure of the starter clutch assembly needle bearing, which caused the engine to develop less than full rated power and the airplane to achieve less than expected climb performance. Factors were noncompliance of a service bulletin, unsuitable terrain on…NTSB DEN00FA007Accident · 1 fatalField investigationFinal reportGardner Varieze · Quemado, NMThe pilot's selection of an unsuitable landing area on which to make a precautionary landing, and his excessive airspeed during landing touchdown. Factors were the ingestion of the foam air filter into the throat of the injector, and the pilot's failure to…NTSB FTW98LA102Accident · Serious injuriesLimited investigationFinal reportMartin Varieze · Artesia, NMThe pilot's inadequate compensation for the crosswind. Factors were the prevailing crosswind and the pilot's lack of total experience in type of aircraft.NTSB FTW98FA024Accident · 1 fatalField investigationFinal reportCessna 150M · Deming, NMThe loss of engine power due to fuel contamination. Contributing was unsuitable terrain consisting of high vegetation and sand.NTSB FTW97LA303Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Los Alamos, NMThe fuel exhaustion due to the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.NTSB FTW96LA311Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Los Lunas, NMthe pilot's improper weather evaluation. Factors were the dust devil and the turbulence.NTSB FTW95LA038Accident · No injuriesLimited investigationFinal reportCessna 150M · Radium Springs, NMFuel exhaustion due to the pilot's inaccurate fuel consumption calculations. A factor was the lack of suitable terrain available for the forced landing.NTSB FTW92LA019Accident · No injuriesLimited investigationFinal reportCessna 150J · Hatch, NMFuel exhaustion as a result of the pilot's failure to refuel and his poor preflight and inflight planning. Factors were the unsuitable mountainous terrain at the pilot's disposal and the unfavorable winds aloft.NTSB DEN89LA223Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Carlsbad, NMThe pilot failed to refuel the airplane in a timely manner which resulted in fuel exhaustion.NTSB DEN88LA171Accident · No injuriesLimited investigationFinal reportCessna 150 · Albuquerque, NMThe instructor (CFI) & student plt were on an instructional flt. The CFI rprtd that while climbing thru aprx 150' AGL, the acft enctrd a downdraft. He took the controls, but the acft descended to about 10 ft AGL. The CFI elected to land immediately to avoid a…NTSB DEN86FA170Accident · 1 fatalField investigationFinal reportCessna A150K · Silver City, NMThe student plt took a private plt for a sight seeing ride. The acft was over gross weight and the density alt was calculated to be 9,292 feet. On an approach to landing the student plt elected to go around. The surviving plt said that in a steep bank the…NTSB DEN85LQA05Accident · No injuriesFinal reportCessna 150M · Santa Fe, NMThe plt experienced a hard landing while on a solo x-country flt. The plt reported the flt had been delayed until mid-afternoon because of mechanical problems at by that time the winds had picked up. The student plt also reported having little dual experience…NTSB DEN84LQA02Accident · No injuriesFinal reportLighthizer, Richard E. Lighthizer Special · Gallup, NMThe pilot/builder of this ultra-light had flown from oshkosh, WI to Gallup, NM without incident. During his attempted take-off from Gallup he allowed the acft to veer off the rwy to the left. After the acft rolled into the grasshe regained directional control…NTSB FTW82FQA26Accident · Serious injuriesFinal reportCessna 150 · La Plata, NMAcft struck a power line which crossed a road at about 40 ft AGL. The acft was observed flying at low altitude in the area prior to the accident.NTSB FTW82DQD03Accident · No injuriesClosedCessna 150 · Las Cruces, NMNTSB FTW80FQA43Accident · No injuriesClosedCessna 150M · Albuquerque, NMNTSB DEN80FQG01Accident · No injuriesClosedCessna 150L · Hobbs, NMNTSB DEN79DQA17Accident · No injuriesClosedCessna 150 · Farmington, NMNTSB DEN78FQD29Accident · No injuriesClosedCessna 150 · Vado, NMNTSB DEN78FQA38Accident · No injuriesClosedCessna 150G · Albuquerque, NMNTSB DEN78FQA14Accident · No injuriesClosedCessna 150H · Roswell, NMNTSB DEN77DQA47Accident · No injuriesClosedCessna 150 · Santa Fe, NMNTSB DEN77FQA38Accident · No injuriesClosedCessna 150K · Alburquerque, NMNTSB DEN77DQD20Accident · No injuriesClosedCessna 150 · Hachita, NMNTSB DEN77DQA30Accident · No injuriesClosedCessna 150L · Espanola, NMNTSB DEN77FQA24Accident · No injuriesClosedRose A&M A-4C · Aztec, NMNTSB DEN77FQA01Accident · No injuriesClosedCessna 150 · Valencia, NMNTSB DEN76DQD31Accident · No injuriesClosedCessna 15OJ · Silver City, NMNTSB DEN76FQA56Accident · Minor injuriesClosedCessna 150 · Tucumcari, NMNTSB DEN7LFQA10Accident · Serious injuriesClosedCessna 150 · Corona, NMNTSB DEN7LFQD04Accident · No injuriesClosedCessna 150 · Lordsburg, NMNTSB DEN75DQD22Accident · No injuriesClosedCessna 150 · Carlsbad, NMNTSB DEN75FQA27Accident · No injuriesClosedCessna 150 · Las Vegas, NMNTSB FTW75DQG27Accident · No injuriesClosedCessna 150 · Texico, NMNTSB DEN75FQD08Accident · Serious injuriesClosedCessna 150 · Condran Aaf, NMNTSB DEN74DQG59Accident · No injuriesClosedCessna 150 · Tumcumcari, NMNTSB DEN74DQD10Accident · No injuriesClosedCessna 150 · Las Cruces, NMNTSB DEN74DQA11Accident · No injuriesClosedCessna 150L · Moriarity, NMNTSB DEN73DQA42Accident · No injuriesClosedCessna 150F · Albuquerque, NMNTSB DEN73DQA21Accident · No injuriesClosedCessna 150 · Aztec, NMNTSB DEN73FQA10Accident · No injuriesClosedCessna 150 · Albuquerque, NMNTSB DEN72FQA40Accident · No injuriesClosedCessna 150E · Waterflow, NMNTSB DEN72FQA26Accident · No injuriesClosedCessna 150F · Cedar Crest, NM