NTSB investigations: Continental 0-200 series, ND
39 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 | 1 |
|---|---|
| 1965 | 2 |
| 1966 | 2 |
| 1967 | 1 |
| 1968 | 3 |
| 1969 | 1 |
| 1970 | 2 |
| 1972 | 1 |
| 1973 | 1 |
| 1974 | 1 |
| 1975 | 3 |
| 1976 | 1 |
| 1977 | 1 |
| 1978 | 1 |
| 1979 | 1 |
| 1980 | 1 |
| 1981 | 2 |
| 1986 | 3 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 2000 | 1 |
| 2002 | 1 |
| 2004 | 1 |
| 2006 | 1 |
| 2010 | 1 |
| 2016 | 1 |
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\" = 'ND' 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" = 'ND' 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 CEN16LA350Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Upham, NDThe pilot's failure to obtain a proper aimpoint during landing due to reduced visibility from the setting sun.NTSB CEN11CA056Accident · Minor injuriesData collectionFinal reportCessna 150H · Kenmare, NDThe pilot's inadequate landing flare and recovery from a bounced landing.NTSB CHI06CA229Accident · No injuriesData collectionFinal reportCessna 150 · Jamestown, NDThe pilot's inadequate preflight planning resulted in the pilot not attaining the proper takeoff climb and failure to maintain terrain clearance. Contributing factors included the transmission wires, the row of trees, and the field of corn.NTSB CHI05LA012Accident · 1 fatalLimited investigationFinal reportCessna 150M · Ashley, NDThe non-instrument rated pilot's continued flight into known adverse weather conditions and his not maintaining aircraft control during cruise flight. Factors present were the night condition and low ceilings.NTSB CHI03LA019Accident · Minor injuriesLimited investigationFinal reportCessna 150M · New Town, NDThe pilot's failure to maintain terrain clearance and his inadequate in-flight planning/decision. Contributing factors are the pilot becoming lost/disoriented and night conditions.NTSB CHI01LA040Accident · No injuriesLimited investigationFinal reportCessna 150K · Minot, NDthe student pilot's inability to maintain aircraft control on the ground. Factors relating to the accident were the high winds, the slush-covered taxiway, the snowbank, inadequate preflight planning by the flight instructor, and the instructor pilot's failure…NTSB CHI94LA345Accident · No injuriesLimited investigationFinal reportCessna 150G · New Town, NDThe pilot's improper use of wing flaps and premature lift-off. The pilot's poor preflight preparation was a factor.NTSB CHI93LA099Accident · No injuriesLimited investigationFinal reportCessna 150M · Stanley, NDThe student pilot's delayed use of carburetor heat. The soft terrain in the landing area was a factor.NTSB CHI91LA075Accident · No injuriesLimited investigationFinal reportCessna 150 · Rolla, NDCompensation for wind was inadequate anad directional control not maintain by the PIC. Contributing factors were: snow covered runway, gusty crosswind, and a snowbank.NTSB CHI90FA214Accident · 2 fatalField investigationFinal reportCessna 150L · Donnybrook, NDThe pilot's failure to maintain airspeed while maneuvering in hilly terrain. Contributing factors were the pilot's failure to maintain adequate altitude and the surrounding steeply rising terrain.NTSB DEN89LA097Accident · No injuriesLimited investigationFinal reportCessna 150 · Garrison, NDImproper flare by the student and inadequate supervision of the flight by the CFI which damaged the nose gear and restricted movement of the nosewheel steering and rudder control.NTSB DEN86LA248Accident · No injuriesLimited investigationFinal reportCessna 150J · Goodrich, NDPlt said he was flying low and chasing black birds from his sunflower fields. Terrain was rolling hills. Plt said he made one pass over field and was turning around for another pass. 'I got my airspeed too low and started to stall. I brought it out of the…NTSB DEN86LA084Accident · No injuriesLimited investigationFinal reportCessna 150L · Watford City, NDThe acft made a hard landing on rwy 30 at Watford City muni arpt, ND, and was substantially damaged. The student plt said the accident occurred on the third touch-and-go. The plt said he used only 10 degrees of flaps. He noted some turbulence and an increase…NTSB DEN86LA063Accident · No injuriesLimited investigationFinal reportCessna 150H · West Fargo, NDAccording to the student plt, he was practicing touch and go landings, when the acft veered off the side of the rwy and contacted a snow bank. The plt indicated he had a total flt time of apx 23 hrs, including 1.5 hrs solo. This was his third solo flt.NTSB DEN81DTG03Accident · No injuriesClosedCessna 150 · Trotter, NDNTSB DEN81FTG21Accident · No injuriesClosedCessna 150 · Lidgerwood, NDNTSB DEN80DTG17Accident · No injuriesClosedCessna 150 · Oakes, NDNTSB MKC79FTG08Accident · No injuriesClosedCessna 150M · Mercer, NDNTSB MKC78FTG03Accident · No injuriesClosedCessna 150K · Cavalier, NDNTSB MKC77DTG03Accident · No injuriesClosedCessna 150 · Wahpeton, NDNTSB MKC77DTG01Accident · No injuriesClosedCessna 150 · Keene, NDNTSB MKC76DTG09Accident · Minor injuriesClosedCessna 150 · Kulm, NDNTSB MKC76DTG04Accident · Minor injuriesClosedCessna 150 · Walhalla, NDNTSB MKC75FTG19Accident · No injuriesClosedCessna 150 · Reynolds, NDNTSB MKC75FTG15Accident · No injuriesClosedCessna 150 · Devils Lake, NDNTSB MKC74DTG04Accident · No injuriesClosedCessna 150 · Mayville, NDNTSB MKC73FTG08Accident · No injuriesClosedCessna 150K · Cavalier, NDNTSB MKC71DDD16Accident · No injuriesClosedCessna 150F · Cooperstown, NDNTSB MKC70FDD06Accident · No injuriesClosedCessna 150G · Minot, NDNTSB MKC70D0076Accident · No injuriesClosedCessna 150 · Fryburg, NDNTSB MKC69F0330Accident · No injuriesClosedCessna 150G · Langdon, NDNTSB MKC69D0219Accident · No injuriesClosedCessna 150 · Fort Rice, NDNTSB MKC68F0512Accident · No injuriesClosedCessna 150 · Grand Forks, NDNTSB MKC68F0233Accident · Minor injuriesClosedChampion ECA · Jamestown, NDNTSB MKC67F0344Accident · No injuriesClosedCessna 150 · Cleveland, NDNTSB MKC67F0358Accident · Minor injuriesClosedCessna 150A · Tioga, NDNTSB MKC66F0271Accident · Minor injuriesClosedCessna 150 · Grand Forks, NDNTSB MKC66F0124Accident · No injuriesClosedCessna 150 · Hatton, NDNTSB UNK64X3418Accident · No injuriesClosedCessna 150 · Jamestown, ND