NTSB investigations: Continental TSIO-360 series
500 cases on aircraft whose registry engine model is Continental TSIO-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.
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 ('17019', '17023'))
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 ('17019', '17023'))
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 ATL83LA196Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Augusta, GAThe acft landed hard, boundced several times and collapsed the nose gear. An ATC specialist on duty said he observed theacft bounce and each time it bounced it seemed to bounce higher. On the fourth bounce the nose gear collapsed. The acft skidded 200 feet on…NTSB NYC83FA121Accident · 1 fatalField investigationFinal reportMooney M-20K · Old Lyme, CTThe acft collided with the ground in IMC after the plt reported he lost his vacuum instruments. The flt originated at mattituck, NY with a destination of lebanon, NH. After departure the plt was cleared to climb to 7000 ft. the instrumentrated pilot was on an…NTSB DEN83FA111Accident · No injuriesField investigationFinal reportPiper PA28R-201T · Aurora, COThe plt received a jump start because the battery failed to start the eng. After departure & leveling of at 10,000 ft, he was concerned with the 1 inch of rime ice he had picked up & got an updated wx briefing from flt watch. He asked for & received a…NTSB MKC83LA092Accident · No injuriesLimited investigationFinal reportMooney M20K · Trenton, NEThe acft was climbing through 11500 to 12000 ft MSL when the engine made a loud noise followed by a lurch. The oil pressure dropped to zero and the engine developed a roughness. The plt said he shut the engine down at this time, the plt advised denver ARTCC…NTSB ATL83FA145Accident · 5 fatalField investigationFinal reportPiper PA-34-200T · Roanoke, VAThe acft was on a x-country from buffalo, NY to new port richey, FL. The plt made an en route stop at painsville, OH, then proceeded toward greensboro, NC. While en route, he elected to land at Roanoke, VA because his fuel would be low if he continued to…NTSB ANC83IA058Incident · No injuriesIncident investigationFinal reportPiper PA34-200T · Palmer, AKDuring touch go landing the student pilot placed the landinggear handle in the up polition while still on the ground, and immediately placed it in the down position. The gear collapsed. The instructor stated that the student appeared to be fatigued.NTSB CHI83LA113Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Jackson, MIComplete electrical failure occurred at 8,000 ft. the plt diverted to Jackson & the acft landed wheels-up. The plt laterstated that he thought he was familiar with the emergency gear extension procedures in the flt manual but that he might not have put the…NTSB FTW83LA103Accident · Minor injuriesLimited investigationFinal reportCessna P337H · La Porte, TXShortly after lift-off, the acft started its initial climb, then entered a slow descent. The flight was continued until the acft collided with a tv cable, suspended below telephone cables on the same poles. The acft contacted the ground, bounced & became…NTSB MKC83FA060Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · Salem, MODuring the 0910 telephone wx briefing by the st. louis fss, the plt mentioned that there was ground fog in the Salem area. At about 1010 the plt departed from rwy 16, made a left turn & crossed the arpt heading north. A witness who drovethe plt to the arpt…NTSB SEA83FYM04Accident · No injuriesFinal reportMooney M20K · Dufur, ORThe aircraft collided with an irrigation pipe line and fence during rollout of a forced landing after engine failure. The engine stopped while the aircraft was cruising en route. The pilot remained in radio contact throughout the emergency and landed in a…NTSB LAX83LVD02Accident · No injuriesFinal reportCessna 172 · Gualala, CACessna 172, N29150, & Piper PA-28, N8465Y, were both departing from a pvt, unctld arpt at the same time, but from opposite drctns on the same rwy. Th rwy was crowned in the center which prevented line-of-sight to acft on opposite ends. Each plt stated that he…NTSB DEN82DA202Accident · No injuriesFinal reportPiper PA-34 · Langdon, NDCabin door came open in flight and pilot made a precautionary landing. During roll-out nose gear collapsed as aircraft weight settled on it since it had not fully extended.NTSB ATL82DA253Accident · No injuriesFinal reportPiper PA-34 · Campbellsville, KYWhile taxiing to a hangar the left wheel went off the taxiway causing the left gear to collapse.NTSB ANC82DAG60Accident · 3 fatalFinal reportPiper PA-28R · Dillingham, AKPilot collided with mountainous terrain at the 1400 foot level. He proposed flight on V-452 which does not exist in that area. V-462 would have been appropriate but his position did not coincide with that route. He was on a VFR flight plan. Twilight ended…NTSB FTW82DA311Accident · No injuriesFinal reportPiper PA-34-200T · Eagle Pass, TXThe pilot stated that he overflew the ranch strip and looked it over before landing. He stated that he touched down on the first 200 ft of the 2200 ft, asphalt runway, but each time the brakes were applied, the wheels would lock and skid due to loose gravel…NTSB SEA83FA196Accident · 1 fatalField investigationFinal reportMooney M-20 · Sandy, ORThe acft crashed into rising terrain in marginal weather conditions. No flt plan had been filed. The acft crashed 25 miles from the takeoff point on 6/12/82 and was missing until 9/9/83. The pilot had received a weather briefing from portland fss indicating…NTSB FTW82DA194Accident · No injuriesFinal reportPiper PA-28-236 · Clayton, NMThe pilot reported that during flight, the engine lost power. He tried to land on a nearby airport. However, unexpectedly strong winds were encountered and he made a forced landing in a pastured when he saw he could not reach the airport. During the landing,…NTSB LAX82DA176Accident · No injuriesFinal reportPiper PA-28-201T · Van Nuys, CADuring flight at about 1500 ft, the engine suddenly lost power and the propeller stopped turning. The pilot attempted a restart, but the starter would not turn the propeller. The pilot maneuvered to make a forced landing at the Van Nuys airport. The aircraft…NTSB FTW82FQD10Accident · 4 fatalFinal reportMooney M20K · Van Horn, TXN99996 departed riverside, CA on a flight to nacogdoches, TX the aircraft made a refueling stop in deming, NM, the last known en route position. The left seat pilot held a pvt certificate, the right seat pilot was a former FAA designated pilot examiner.…NTSB CHI82DA120Accident · No injuriesFinal reportPiper PA-34 · Gaylord, MIDuring a night visual approach the aircraft landed about 90 ft short of the runway. The aircraft slid across the ground onto the runway pavement and swerved to the right striking a runway light and ending up on a snowbank.NTSB DEN82DA055Accident · No injuriesFinal reportPiper PA-28R-201T · Longmont, COThe pilot reported that he made a normal approach and touched down in the landing zone as defined by the VASI. However, during the landing roll, the right brake was inoperative. He was unable to stop on the remaining runway while rolling straight ahead. About…NTSB FTW82FQA13Accident · Serious injuriesFinal reportPiper PA-28RT-201T · Toadlena, NMThe non-instrument rated pilot in Piper PA-28RT, N29665, was using a call sign, N1104X, which was the registration number of a destroyed PA-32. He was cleared to climb to FL200, but as he continued, his speech became slurred. He acknowledged an artc…NTSB LAX82FA074Accident · 1 fatalField investigationFinal reportPiper PA-34 · Near Sonoma, CAThe pilot proceeded VFR toward a private strip after an instrument approach to napa county airport. The visibility was not good and the aircraft collided with a hillside while en route. About 5 mi north, the weather at the napa county airport was 500 ft…NTSB LAX82IA062Incident · No injuriesIncident investigationFinal reportPiper PA-28R-201T · Truckee, CADuring the landing roll the aircraft veered sharply to the left and struck a snowbank, collapsing the nose and left main landing gear. Inspection of the runway revealed the presence of several large ice chunks adhering to the runway surface.NTSB MIA82FA038Accident · No injuriesField investigationFinal reportPiper PA-34-200T · Newport Richey, FLThe pilot departed orlando, Florida on a VFR flight to tampa, Florida. At about 1534 EST, the pilot contacted tampa approach control for VFR flight following. Approach control reported radar contact, and at the same time, issued an advisory, "traffic at…NTSB FTW82FPJ11Accident · No injuriesFinal reportPiper PA-28R-201T · Watonga, OKThe pilot stated that the engine lost oil pressure and shortly thereafter quit. During the forced landing the pilot veered the aircraft off the highway he had elected to land on due to oncoming traffic. The aircraft sustained substantial damages due to the…NTSB LAX82FA018Accident · 2 fatalClosedPiper PA-34 · Oceanside, CANTSB SEA82FA005Accident · 3 fatalClosedCessna 421C · Shoshone, IDNTSB FTW82FPD02Accident · No injuriesClosedPiper PA-34 · Henrietta, TXNTSB ANC81DAG76Accident · No injuriesClosedPiper PA-34 · Chignik, AKNTSB MIA81DA108Accident · No injuriesClosedMooney M20K · Defuniak Sprgs, FLNTSB SEA81FA047Incident · No injuriesClosedPiper PA-34 · Boise, IDNTSB FTW81DRG46Accident · No injuriesClosedPiper PA-34 · Crystal City, TXNTSB SEA81FA037Accident · No injuriesClosedPiper PA-28R · Orcas, WANTSB LAX81FUD03Accident · No injuriesClosedPiper PA-28R · Santa Monica, CANTSB ATL81FA077Accident · 2 fatalClosedPiper PA-28R · Huttonville, WVNTSB CHI81FA055Accident · 1 fatalClosedMooney M20K · Campbell Hill, ILNTSB ATL81FA070Accident · Serious injuriesClosedMooney M20K · Churchville, MDNTSB NYC81FHD15Accident · Minor injuriesClosedMooney M20K · Atlantic City, NJNTSB MKC81DCQ15Accident · Minor injuriesClosedPiper PA-28R · Goodland, KSNTSB MIA81DKT14Accident · No injuriesClosedPiper PA-28R · Everglades Cty, FLNTSB LAX81FA026Accident · 3 fatalClosedMooney M20K · Battle Mt, NVNTSB FTW81FPM05Accident · Serious injuriesClosedMooney M20K · Afton, OKNTSB DEN81FA010Accident · 5 fatalClosedMooney MZ0K · Grand Junction, CONTSB LAX81DUJ24Accident · No injuriesClosedPiper PA-34 · Whiteriver, AZNTSB MKC80FA048Accident · 3 fatalClosedPiper PA-28R · Carroll, IANTSB FTW80DRJ32Accident · No injuriesClosedMooney M20K · Mt. Pleasant, TXNTSB CHI80FER57Accident · No injuriesClosedPiper PA-34 · Albert Lea, MNNTSB LAX81DUJ74Accident · No injuriesClosedPiper PA-34 · Flagstaff, AZNTSB DEN80FTM25Accident · No injuriesClosedPiper PA-28 · Cedar City, UT