Final NTSB investigations: AiResearch 331SER 705HP
8 cases on aircraft whose registry engine model is AiResearch 331SER 705HP. 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 per year
| 1978 | 1 |
|---|---|
| 1985 | 1 |
| 1988 | 1 |
| 1991 | 1 |
| 1994 | 1 |
| 2002 | 1 |
| 2007 | 1 |
| 2011 | 1 |
Where
Open the mapLatest cases
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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('01506'))
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."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('01506'))
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 ERA12CA128Accident · No injuriesData collectionFinal reportMitsubishi MU-2B-20 · Picayune, MSThe pilot's excessive rate of descent during the landing flare/touchdown, which resulted in a hard landing.NTSB SEA07LA145Accident · No injuriesLimited investigationFinal reportSwearingen SA-226T · McCall, IDThe nosewheel steering system's uncommanded turn during the landing roll, making it impossible for the pilot to maintain directional control. Factors include a snow bank running parallel to the side of the runway.NTSB LAX02FA251Accident · 4 fatalField investigationFinal reportAero Commander 690A · Bishop, CAThe pilot's failure to maintain an appropriate terrain clearance altitude while maneuvering in the traffic pattern due to the sensory and visual illusions created by a lack of ground reference lights and/or terrain conspicuity, and the dark nighttime…NTSB NYC94FA064Accident · 1 fatalField investigationFinal reportSwearingen SA-26AT · Winchester, VAThe pilot's decision to operate the airplane with known deficiencies in the fuel quantity measuring system which resulted in a power loss due to fuel starvation, followed by improper emergency procedures which resulted in a loss of control inflight and…NTSB ANC91IA037Incident · No injuriesIncident investigationFinal reportBeech C-45H · Shageluk, AKThe accident was the pic's failure to properly determine the required width of runway needed by their airplane and inadequate snow removal. Contributing to the accident was the snow berm and the copilot's misjudgment of runway width.NTSB BFO89LA013Accident · No injuriesLimited investigationFinal reportSwearingen SA-226T · Washington, DCPilots failure to maintain control of the airplane during a touch and go landing.NTSB FTW85FA259Accident · 1 fatalField investigationFinal reportSwearingen SA-26AT · Rocksprings, TXAs the acft was climbing thru 14,800' for 19,000', the plt reported a rapid decompression. Two minutes later, he reported that he has lost the tail. Acft impacted in an inverted flat spin and the tail and a section of empennage were found about 3/4 mile away…NTSB DEN78FA065Accident · 6 fatalClosedMitsubishi MU-2J · Raton, NM