NTSB investigations: AiResearch TPE331 series, ND
5 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 per year
| 1981 | 1 |
|---|---|
| 1996 | 1 |
| 2005 | 1 |
| 2012 | 1 |
| 2018 | 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.\"eventStateOrRegion\" = 'ND' 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 ('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."eventStateOrRegion" = 'ND' 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 ('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 CEN19FA030Accident · 3 fatalClass 2 · FieldFinal reportCessna 441 · Harmon, NDThe pilot's failure to maintain control of the airplane in dark night conditions that resulted in an in-flight positive overload failure of the wings and the subsequent in-flight breakup of the airplane.NTSB CEN13IA107Incident · No injuriesIncident investigationFinal reportSwearingen SA227-AC · Williston, NDThe snowplow driver’s failure to ensure that the runway was clear before driving onto it, which resulted in a runway incursion with a departing airplane.NTSB CHI05CA246Accident · No injuriesData collectionFinal reportAyres S2R-G10 · Davenport, NDThe pilot failed to gain suffient altitude during takeoff in order to clear the corn crop at the end of the runway. A factor associated with the accident was the corn crop.NTSB CHI96LA162Accident · No injuriesLimited investigationFinal reportSwearingen SA226TC · Fargo, NDthe flight crew did not comply with the gear down and lock checklist. The factors were a jammed nose gear and inattentive preflight planning/preparations by the pilot-in-command.NTSB DEN82FTG02Accident · No injuriesClosedMitsubishi MU-2B · Williston, ND