Skip to content

NTSB investigations: Continental IO-360 series, PA

14 cases on aircraft whose registry engine model is Continental IO-360 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

19652026

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" = 'PA' 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 ('17025', '17045')) 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\" = 'PA' 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 ('17025', '17045'))
  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" = 'PA' 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 ('17025', '17045'))
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 ERA09CA402Accident · No injuriesData collectionFinal reportCessna T337 · Pittsburgh, PAThe pilot's failure to obtain the proper touchdown point during landing.Jul 14, 2009 · N21NC · Substantial damage NTSB OPS08IA015Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2C1 · Allentown, PAThe failure of both tower controllers to maintain awareness of the position of N736GV and ensure that the aircraft was clear of the runway before issuing a takeoff clearance to ASH7138.Sep 19, 2008 · N506MJ · 2 aircraft · No damage NTSB NYC03LA091Accident · No injuriesLimited investigationFinal reportCessna 172K · Burnham, PAThe pilot's failure to maintain directional control during the takeoff roll.Apr 27, 2003 · N758XB · Substantial damage NTSB NYC02LA113Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-200 · Gettysburg, PAThe pilot's failure to accurately compute takeoff performance and his failure to establish a positive climb resulting in a collision with trees.Jun 11, 2002 · N9357N · Substantial damage NTSB NYC98LA153Accident · Serious injuriesLimited investigationFinal reportCessna 337G · Jeanette, PAThe pilot's delay in applying the brakes during the landing rollout.Jul 26, 1998 · N72326 · Substantial damage NTSB NYC88FA072Accident · 1 fatalField investigationFinal reportCessna 337E · Friedens, PAThe 24 year old unlicensed pilot made an unauthorized flight in his father's aircraft. The Cessna 337 was observed to manuever in the vicinity of the airport at a low altitude in and out of the clouds. The aircraft was then observed to come out of the clouds…Feb 2, 1988 · N1201M · Destroyed NTSB NYC85LA111Accident · No injuriesLimited investigationFinal reportCessna R172K · Glen Campbell, PADuring flt, the plt flew over svrl coal strip mines at low alt & at low airspeed. He had the acft trimmed for 60 KTS & had one notch of flaps extended. He reported that as he was flying in straight & level flt, the acft seemed to be drawn down into a valley.…May 10, 1985 · N736FG · Substantial damage NTSB NYC85FA103Accident · 5 fatalField investigationFinal reportMooney MO-20J · Lock Haven, PAPreflt wx briefings were issued to the plt that forecasted moderate icing & turbulence from 3000 to 14000 ft across the planned route. An IFR flt plan was filed and during the flt the plt reported engine problems at 1100 ft MSL. During vectors to closest arpt…Apr 7, 1985 · N5764D · Destroyed NTSB NYC84FHD02Accident · 1 fatalFinal reportCessna 337 · Coatsville, PAAfter touchdown about 2,000 ft down the 4,600 x 100 ft rwy the acft bounced back into the air. Witnesses observed the acft rt wing drop causing it to veer to the rt toward a line of parked acft. 900 ft from initial touchdown the acft impacted rt wing first in…May 20, 1984 · N213DL · Destroyed NTSB NYC78FGM44Accident · Serious injuriesClosedCessna 337 · Cutty, PAAug 16, 1978 · N1146M · Substantial damage NTSB NYC78FGT09Accident · Minor injuriesClosedBeech A23 · State College, PAJun 15, 1978 · N3521R · Substantial damage NTSB NYC72FHD38Accident · No injuriesClosedBeech B23 · Ambler, PAApr 30, 1972 · N3521R · Substantial damage NTSB NYC67F0124Accident · No injuriesClosedCessna 337 · Kutztown, PAAug 9, 1966 · N2219X · Substantial damage NTSB NYC65F0179Accident · No injuriesClosedMaule M-4 · Mt Pleasant, PAMay 1, 1965 · N4740T · Substantial damage