NTSB investigations: AiResearch TPE331 series
223 cases on aircraft whose registry engine model is AiResearch TPE331 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 ('01514', '01517'))
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 ('01514', '01517'))
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 MKC83IA078Incident · No injuriesIncident investigationFinal reportAero Commander 680W · Kansas City, KSThe number 2 engine failed in cruise flight. Durng descent the landing gear failed to extend. The pilot landed intentional gear up in the sod area adjacent to the runway.NTSB LAX83FA083Accident · 6 fatalField investigationFinal reportMitsubishi MU-2B-60 · Scottsdale, AZThe acft diverted from Scottsdale AZ to a flt course to sedona because of thunderstorms & high winds at Scottsdale, but after a radio conversation with Scottsdale twr, the plt decided to reroute to land at Scottsdale. The plt did not read back the weather…NTSB ANC83IA010Incident · Minor injuriesIncident investigationFinal reportShort Bros. SC7 Series 3 · Barrow, AKThe aircraft was on a round trip flight from Barrow, AK to point hope, AK and return. After landing at point hope, there was a 20 min delay while waiting for the ground crew. The pilot stated that he ran the engines for some 10 min or so due to the high winds…NTSB LAX82DUJ45Accident · No injuriesFinal reportAyres S2R · Goodyear, AZThe aircraft had just been loaded with spray material. The pilot stated that after taking off, he leveled off over cotton at the end of the strip and made a power reduction. At about that time, the aircraft settled into the cotton and hit an embankment. The…NTSB LAX82FA255Accident · Minor injuriesField investigationFinal reportMitsubishi MU-2B · Schellville, CAAt approximately 800 ft down the left side of the rwy the left eng experienced a power loss. The acft swerved off the left side of the rwy colliding with a drainage ditch & coming to rest inverted. Examination of the fuel control unit revealed that the…NTSB FTW82FA173Accident · 2 fatalField investigationFinal reportGulfstream American 980(695) · Carlsbad, NMThe acft crashed about 1/2 mi sw of the departure end of rwy 32L. The rwy had been illuminated at the time of takeoff with the acft making a left turn into an area that was not illuminated toward the mountains. It was a very dark night with an…NTSB MKC82DA015Accident · No injuriesClosedSwearingen SA227 · Lincoln, NENTSB DEN82FTG02Accident · No injuriesClosedMitsubishi MU-2B · Williston, NDNTSB DEN81FA067Accident · No injuriesClosedSwearingen SA266 · Flagstaff, AZNTSB DEN81AA064Accident · 5 fatalClosedMitsubishi MU-2B · Riverton, WYNTSB CHI81FEV29Accident · Serious injuriesClosedAero Comdr 695 · Peoria, ILNTSB CHI81IA025CaseClosedSwearingen SA226 · Indianapolis, INNTSB FTW80DPG16Accident · No injuriesClosedGrumman G-164B · Marked Tree, ARNTSB FTW80FA048Accident · 7 fatalClosedMitsubishi MU-2B · New Orleans, LANTSB LAX80FA005Accident · 2 fatalClosedSwearingen SA26AT · Palo Alto, CANTSB LAX78FUJ75Accident · No injuriesClosedGrumman G-164B · Coolidge, AZNTSB IAD78FLQ17Accident · No injuriesClosedGrumman G-164B · Monticello, KYNTSB MIA78FA079Incident · No injuriesClosedSwearingen 226-TC · Muscle Shoals, ALNTSB MIA77DKJ02Accident · No injuriesClosedAero Comdr 690A · Fayette, ALNTSB FTW76DRA30Accident · No injuriesClosedGrumman G-164A · Damon, TXNTSB CHI70DGG12Accident · No injuriesClosedAero Comdr 680W · Van Wert, OHNTSB MKC69F0135Accident · No injuriesClosedAero Comdr 680T · Minneapolis, MNNTSB ANC67A0021Accident · No injuriesClosedSikorsky S-55 · Galena, AK