NTSB investigations: AiResearch 331SER 1008HP

4 cases on aircraft whose registry engine model is AiResearch 331SER 1008HP. 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

19862026

NTSB investigations: AiResearch 331SER 1008HP per year, 1986–2026: 4 cases
1986	1
1990	1
2003	1
2005	1

Where

Open the map

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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('01512')) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('01512'))
  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 ('01512'))
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 NYC05LA044Accident · No injuriesLimited investigationFinal reportAero Commander 690A · Cleveland, OHThe pilot's failure to maintain directional control during landing, which resulted in an impact with a sign.Jan 4, 2005 · N17HF · Substantial damage NTSB LAX03LA105Accident · Serious injuriesLimited investigationFinal reportAero Commander 690A · Tracy, CAthe failure of the pilot to maintain directional control during the departure roll on a narrow runway. A factor in the accident was the pilot's limited experience in the airplane.Mar 3, 2003 · N132JH · Substantial damage NTSB ATL91TL#01Accident · No injuriesClass 3Final reportAero Commander 690A · Montgomery, ALNov 16, 1990 · N8535 · Substantial damage NTSB DEN86FA128Accident · 1 fatalField investigationFinal reportSwearingen SA226AT · Billings, MTWhile on an IFR flt plan in IMC, the plt executed a missed approach after flying a localizer back course 27 approach. During a subsequent ILS rwy 09L approach, radio and radar contact with the acft was lost lost. The acft wreckage was located on the inbound…May 8, 1986 · N577KA · Destroyed