NTSB investigations: Continental O-470 series
6,204 cases on aircraft whose registry engine model is Continental O-470 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 ('17026'))
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 ('17026'))
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 NYC82DA038Accident · No injuriesFinal reportCessna 182B · Pepperell, MAWhen the pilot arrived at his destination, he landed on an icy runway. Near the end of his landing roll, the aircraft encountered a rut and veered into a snowbank beside the runway. The wind was light and variable.NTSB FTW82DA091Accident · No injuriesFinal reportCessna 182J · Boerne, TXThe pilot attempted a landing on a rough grass strip between two hills. Ground turbulence was encountered and the aircraft stalled. The aircraft bounced and when the pilot attempted a power recovery he collided with a fence.NTSB ANC82DA025Accident · No injuriesFinal reportCessna 180 · Mcgrath, AKThe pilot reported there was no wind on the ground. However,immediately after takeoff he encountered a downdraft which would not allow him to clear trees at the end of the airstrip. Takeoff was on runway 5.wind reported by farewell,AK,located 19MI nw of the…NTSB LAX82DA099Accident · No injuriesFinal reportCessna 182 · Woodland, CAA climb was made to 10,000 ft on a skydiving flight. The pilot reported that after descending to 2000 ft, the engine began to lose power and run rough. He elected to make an off-airport landing in a field. Near the end of the landing roll, the nose gear sank…NTSB SEA82DA035Accident · No injuriesFinal reportCessna 182P · Creswell, ORDuring preflight the pilot found water in the fuel system. After fuel drainings and sample checks were completed the pilot started the engine and initiated taxi for takeoff. During taxi and engine runup the engine stopped several times. After repeated fuel…NTSB LAX82FUJ29Accident · Minor injuriesFinal reportCessna 182C · Eloy, AZThe aircraft crashed near the end of a runway on a dark night. The pilot stated to the police that he had run out of fuel. The police found weapons, drugs, and liquor in the pilot's possession. An estimated 3 gallons of fuel was found in each tank. According…NTSB FTW82DA066Accident · No injuriesFinal reportCessna A185F · Near Patterson, LAAfter landing the pilot began to step taxi on an unfamiliar canal to a drilling rig location. While negotiating a turn in the canal, the left wing struck a tree limb. The aircraft veered to the left and the right wing dropped and hit the water.NTSB MIA82FA044Accident · 8 fatalField investigationFinal reportCessna 182B · W. Of Homestead, FLCessna N2280G and Piper N7361P collided in midair in a remote area of the everglades national park, Florida.NTSB LAX82DA065Accident · No injuriesFinal reportCessna 180 · San Jose, CABellanca N71681 was awaiting clearance for takeoff when Cessna N3343D taxied into the turning propeller during a positioning maneuver.NTSB CHI82DA036Accident · No injuriesFinal reportCessna 182H · Peoria, ILThe owner of the aircraft was a student pilot. Another person, who was a private pilot, stated that he was invited to ride along. The private pilot reported that he was unaware that the aircraft owner was not a certificated pilot. After returning from a local…NTSB FTW82FQG14Accident · 2 fatalFinal reportCessna 182 · Pampa, TXN58947 was purchased by the pilot the day of the accident. According to a flight instructor who sold the aircraft, the pilot received dual instruction for a checkout in the aircraft and currency for night flight. According to witnesses, the pilot did not…NTSB ATL82DA045Accident · No injuriesFinal reportCessna 182L · Conyers, GAThe destination airport is a private strip that is oriented on a 150/330 degree heading. The northwest end is enclosed by tall trees. Accordingly, most landings are made toward the northwest regardless of wind direction. The pilot landed on runway 33 which…NTSB LAX82FA045Accident · 3 fatalField investigationFinal reportCessna 182N · Escondido, CABefore takeoff, the pilot received a complete weather briefing. The briefer warned him that the weather system in southern California was extremely hazardous and advised him several times not to go. The briefing included numerous pilot reports that confirmed…NTSB FTW82DA045Accident · No injuriesFinal reportCessna 180K · S.E. Of Houma, LAThe pilot elected to takeoff from a canal with a quartering tailwind due to approaching fog. The aircraft drifted left and its wing struck a piling.NTSB DEN82DA019Accident · No injuriesFinal reportCessna 180E · Cedar City, UTThe pilot stated that he intended to fly close to the field surface dragging the tailwheel of the aircraft to determine snow/field conditions. During the low pass he used three notches of flap and added full power with the propeller at full pitch. When the…NTSB NYC82DA022Accident · No injuriesFinal reportCessna 310 · Butler, PAThe pilot arrived at the destination at dusk. He circled the airport at pattern altitude to check the wind and runway condition. He noted that the runway was covered with snow. A long approach was made to runway 36 in a calm wind condition. Just prior to…NTSB DEN82FTE16Accident · No injuriesFinal reportCessna 180 · Saquache, CODuring a round-robin VFR flight the pilot landed at cochetopa strip and shut down for 1 hour. The pilot stated that at the time of takeoff the wind velocity had increased to 20-25 knots with almost a direct crosswind. During takeoff the aircraft drifted left…NTSB LAX82FJA03Accident · No injuriesFinal reportCessna 305 (L-19) · Mokuleia, HIDuring the landing roll, the aircraft began to veer left and would not respond to right rudder or brake application. The plane continued off the left side of the runway, and the right wing was damaged. An investigation revealed that the right brake had…NTSB DEN82FTE15Accident · No injuriesFinal reportCessna 182A · Steamboat Sprin, COAfter the pilot entered the traffic pattern for landing, he extended his downwind leg to accomodate the departure of another aircraft. The pilot reported that he pushed the throttle forward as he turned base, but the engine failed to respond. During a forced…NTSB ANC82FAG14Accident · 3 fatalFinal reportCessna 180 · Skwenta, AKThe aircraft departed finger lake at approximately 1000 ast for a short ice fishing trip to fish lakes. The aircraft never returned and a search was started. The wreckage was located near the kahiltna river about 5 miles from the intended destination on…NTSB LAX82FA028Accident · 2 fatalClosedLing-T-Vogt A7E · Fallon, NVNTSB LAX82FA027Accident · 4 fatalClosedCessna 182L · Coalinga, CANTSB CHI82DAMS1Accident · 3 fatalClosedCessna 182A · Missing AircraftNTSB CHI82FER13Accident · No injuriesClosedCessna 182B · Eden Prairie, MNNTSB CHI82FA016Accident · 2 fatalClosedCessna 182E · Platteville, WINTSB LAX82FVG07Accident · Serious injuriesClosedCessna 182H · Sacramento, CANTSB SEA82DYK06Accident · No injuriesClosedCessna 182 · Redmond, ORNTSB MIA82DLD08Accident · No injuriesClosedCessna 182 · Vero Beach, FLNTSB MKC82FCA04Accident · No injuriesClosedCessna 182Q · Eunice, MONTSB FTW82DPG04Accident · No injuriesClosedCessna 182G · Hughes, ARNTSB MKC82DCQ05Accident · No injuriesClosedCessna 182 · Yates Center, KSNTSB DEN82FTI08Accident · No injuriesClosedCessna 182 · Chinook, MTNTSB NYC82FFJ08Accident · No injuriesClosedCessna 180K · Jamestown, NYNTSB NYC81FNC01Accident · Minor injuriesClosedCessna 180 · Millinocket, MENTSB SEA82DYE02Accident · No injuriesClosedCessna 182 · Everett, WANTSB ANC82DAD02Accident · No injuriesClosedCessna 182 · Sullivan River, AKNTSB FTW82DQG02Accident · No injuriesClosedCessna 182J · Muleshoe, TXNTSB ATL82DLQ02Accident · Minor injuriesClosedCessna 182P · Hazard, KYNTSB FTW82DRJ02Accident · Minor injuriesClosedCessna 182 · Farmerville, LANTSB MKC82DCD02Accident · No injuriesClosedCessna 182 · Webster City, IANTSB DEN81DTE03Accident · No injuriesClosedCessna 180 · Canon City, CONTSB NYC82FNA02Accident · Serious injuriesClosedCessna 182 · East Pepperell, MANTSB CHI81FER72Accident · Minor injuriesClosedCessna 180 · Corcoran, MNNTSB ATL81DKJ37Accident · No injuriesClosedCessna 182 · Elberta, ALNTSB ANC81DAG85Accident · No injuriesClosedCessna 180 · Sleetmute, AKNTSB ANC81DAG78Accident · Serious injuriesClosedCessna 180 · Egegik, AKNTSB LAX81FUM19Accident · Serious injuriesClosedCessna 180 · El Cajon, CANTSB CHI81FEC45Accident · No injuriesClosedCessna 182L · Brighton, MINTSB ATL81FKQ28Accident · No injuriesClosedCessna 182 · Batesville, MSNTSB NYC81FHJ16Accident · No injuriesClosedCessna 182E · Mattituck, NY