NTSB investigations: Continental 0-200 series
6,416 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, newest first
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.\"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."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 NYC82DA062Accident · No injuriesFinal reportCessna 150L · Haverhill, MAAfter calling for landing information on UNICOM and receiving no reply the pilot elected to land. During roll-out at approximately 5 mph the aircraft's right main and nose gear encountered a sink-hole causing the right wingtip to hit the ground.NTSB CHI82DA097Accident · No injuriesFinal reportCessna 150 · Wheeling, ILThe student pilot departed Wheeling, IL on a cross-country flight to dubuque, IA; oshkosh, WI and return. The pilot refueled with 17.7 gallons of 100 octane low-lead gasoline at dubuque, but did not refuel at oshkosh. Near milwaukee, he noted that the right…NTSB MKC82DA048Accident · No injuriesFinal reportCessna 150 · Sabetha, KSThe pilot initiated a landing approach to runway 1 with the wind from 280 degrees at 18, gusting 25 knots. He entered final approach in a crab and was lined up with the runway. When over the threshold, the plane started to drift right. It settled to the…NTSB ATL82FA072Accident · 1 fatalField investigationFinal reportCessna 150 · Tilghman Island, MDThe student pilot/owner of the aircraft was endorsed to fly the plane and would fly it from his farm on Tilghman Island to easton, MD for dual instruction. Several days before the accident, he had asked his instructor (ip) to schedule some time for an early…NTSB MKC82DA043Accident · No injuriesFinal reportCessna 150M · Lee'S Summit, MOOn landing the aircraft veered off the left side of the runway and down a bank. The nose gear entered a ditch causing it to fail.NTSB NYC82FA041Accident · Serious injuriesField investigationFinal reportCessna 150G · Erwinna, PAThis was the student's first solo in powered aircraft. He held a private pilot certificate with a glider rating. His takeoff and traffic pattern appeared normal until the last part of his final approach for landing. About 600 ft short of the runway, the…NTSB CHI82DA073Accident · No injuriesFinal reportCessna 150 · Manchester, MIDuring takeoff the student pilot lost directional control and struck a snowbank. The student stated at 40-50 knots the left wheel bogged down in snow or encountered a rut and the aircraft twisted sharply left.NTSB CHI82DA061Accident · No injuriesFinal reportCessna 150 · Franklin, WIWhile practicing a no-flap landing, the student allowed the aircraft to descend below the normal glide path. The instructor told the student that they were going to be low and to add power. Power was added, but soon thereafter, the aircraft touched down short…NTSB LAX82DUG06Accident · Serious injuriesFinal reportCessna 150 · Daggett, CAWhile descending through 4000 ft MSL to land, the engine began to surge. The pilot moved the mixture to full rich and selected carburetor heat, but the engine lost all power. Reportedly, the aircraft was demolished during a forced landing. Disassembly of the…NTSB MKC82DA037Accident · No injuriesFinal reportCessna 150 · Grain Valley, MOThe pilot was attempting to taxi his aircraft back to its tiedown space through 6 to 8 inches of snow. While maintaining clearance on an aircraft on his right the left wing tip struck the tail of a Cessna 140.NTSB SEA82DA025Accident · No injuriesFinal reportCessna 150J · Nr. Colbert, WADuring flight, the instructor asked the student to perfrom a power-off approach-to-landing stall. The student began the maneuver at about 4600 ft with the carburetor heat on. During recovery, he abruptly advanced the throttle and the engine began to lose…NTSB LAX82DVM10Accident · No injuriesFinal reportTaylorcraft F19 · Mt. Hamilton, CAAfter landing, the pilot's right heel slipped off of the right heel brake while he was applying brakes. Subsequently, the aircraft veered to the left before he released the left brake. The right main gear collapsed as the aircraft stopped in a small ditch…NTSB NYC82DA017Accident · No injuriesFinal reportCessna 150L · Caldwell, NJThe student pilot was at the controls during a landing on runway 04. The wind was from 330 degrees at 15 knots. The instructor reported that the plane was slipped to the left on short final, and shortly thereafter, the right wheel struck a snowbank. The…NTSB FTW82FPD08Accident · Serious injuriesFinal reportCessna 150H · Saginaw, TXDuring the takeoff roll, the pilot heard a noise that was followed by a vibration at lift-off. Reportedly, the flight controls did not respond properly while the aircraft was in flight. The pilot returned for landing and held the nose gear off as long as…NTSB FTW82DA042Accident · No injuriesFinal reportCessna 150H · Shreveport, LAThe pilot departed stillwater, ok at 0950 CST on a flight to mcalister, OK. While airborne, he amended his destination to Shreveport, LA with an estimated arrival time of 1251 CST. On his flight plan, he estimated 3 hours of fuel on board. At 1253 CST, the…NTSB CHI82DA020Accident · No injuriesFinal reportCessna 150L · Charlotte, MIAfter returning to the airport, the pilot used full flaps during a crosswind landing. The wind was from 090 degrees, gusting 20 to 25 knots. The pilot stated that he added power when the aircraft stalled at about 10 ft AGL. The plane touched down in snow…NTSB MKC82FCG16Accident · Minor injuriesClosedCessna 150F · Independence, MONTSB LAX82DVM07Accident · No injuriesClosedCessna 150 · Ipomo, CANTSB MKC82FCD05CaseClosedCessna 150F · Keosauqua, IANTSB MIA82DLD11Accident · No injuriesClosedCessna 150L · Cedar Key, FLNTSB LAX82FA030Accident · 2 fatalClosedCessna 150 · Kelso, WANTSB MKC82DCA06Accident · No injuriesClosedCessna 150M · Lutesville, MONTSB LAX82FUA07Accident · No injuriesClosedCessna 150 · Laguna Beach, CANTSB ATL82FKJ07Accident · No injuriesClosedCessna 150 · Birmingham, ALNTSB LAX82FA025Accident · 2 fatalClosedCessna 150M · Antioch, CANTSB DEN82DTK01Accident · No injuriesClosedCessna 150 · Elkton, SDNTSB NYC82FHM04Accident · No injuriesClosedCessna 150 · Newburgh, NYNTSB DEN81DTG03Accident · No injuriesClosedCessna 150 · Trotter, NDNTSB FTW82DQD03Accident · No injuriesClosedCessna 150 · Las Cruces, NMNTSB FTW82FPA05Accident · Minor injuriesClosedCessna 150 · Hillsboro, TXNTSB CHI82FEI02Accident · No injuriesClosedCessna 150J · Willowick, OHNTSB ATL82FKJ06Accident · Serious injuriesClosedCessna 150 · Russellville, ALNTSB NYC82FGM04Accident · No injuriesClosedCessna 150 · Wattsburg, PANTSB DEN82FTM03Accident · No injuriesClosedCessna 150 · Stockton, UTNTSB MKC82FCG05Accident · Minor injuriesClosedCessna 150M · Eldon, MONTSB LAX82DUJ22Accident · No injuriesClosedCessna 150K · Sedona, AZNTSB LAX82DUJ15Accident · No injuriesClosedCessna 150 · Lk Havasu Cy, AZNTSB ATL82FKG03Accident · Minor injuriesClosedCessna 150F · Columbus, GANTSB FTW82FPJ02Accident · Serious injuriesClosedCessna 150 · Asher, OKNTSB MIA82FLA01Accident · Minor injuriesClosedCassutt III-M · St.Augustine, FLNTSB CHI82FET01Accident · No injuriesClosedCessna 150 · Ft Wayne, INNTSB CHI82FEP02Accident · No injuriesClosedCessna 150 · Hamburg, WINTSB CHI82FEP01Accident · No injuriesClosedCessna 150J · Waukesha, WINTSB DEN81FTG21Accident · No injuriesClosedCessna 150 · Lidgerwood, NDNTSB ANC81DAG95Accident · Minor injuriesClosedCessna 150 · Seward, AKNTSB LAX81FA132Accident · 1 fatalClosedCessna 150 · Hemet, CANTSB MIA81FA122Accident · 2 fatalClosedCessna 150G · Ponce De Leon, FLNTSB LAX81FUA15Accident · Minor injuriesClosedCessna 150L · Fullerton, CANTSB NYC81FHM16Accident · No injuriesClosedCessna 150M · Caldwell, NJNTSB ATL81FA117Accident · 1 fatalClosedCessna 150 · Homestead, FL