Final NTSB investigations: Allison 501-D13 series

13 cases on aircraft whose registry engine model is Allison 501-D13 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Final NTSB investigations: Allison 501-D13 series per year, 1964–2026: 13 cases
1964	2
1966	1
1970	1
1973	1
1976	1
1977	1
1980	1
1986	1
2001	1
2004	1
2005	1
2008	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."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 ('03004')) 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.\"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 ('03004'))
  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 ('03004'))
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 CHI08MA270Accident · 3 fatalMajor investigationFinal reportConvair CV-580 · Columbus, OHThe improper (reverse) rigging of the elevator trim cables by company maintenance personnel, and their subsequent failure to discover the misrigging during required post-maintenance checks. Contributing to the accident was the captain’s inadequate…Sep 1, 2008 · N587X · Destroyed NTSB CHI05IA273Incident · No injuriesIncident investigationFinal reportConvair Div. of Gen. Dynamics 440 · Kenosha, WIThe flight crew failed to verify that the cargo was secured before takeoff.Sep 22, 2005 · N181FL · Minor damage NTSB DFW05LA029Accident · No injuriesLimited investigationFinal reportConvair 580 · McAllen, TXThe failure to activate the hydraulic pump which resulted in the pilot's inability to maintain directional control.Dec 4, 2004 · N161FL · Substantial damage NTSB MIA02FA041Accident · Minor injuriesField investigationFinal reportConvair Div. of Gen. Dynamics 340-580STC · Sunny Isles Bch, FLThe inadequate dispatch of the airplane by company personnel prior to the first leg of the flight due to failure of company personnel to prepare a new flight release and weight and balance after considerable time on the ground with the engines operating. Also…Dec 7, 2001 · N582HG · Substantial damage NTSB DEN86FA120Accident · Serious injuriesField investigationFinal reportConvair 580 · Denver, CON73104 was operating as aspen airway flt 416, scheduled pax service from aspen to Denver. The flt proceeded uneventfully until light turb was encounterd near Denver. The captain had authorized the flt attendant to perform beverage svc. After completing the…Apr 25, 1986 · N73104 · No damage NTSB NYC80FA018Accident · Minor injuriesClosedLockheed L-188 · Syracuse, NYJan 18, 1980 · N290F · Substantial damage NTSB NYC77FA040Accident · No injuriesClosedConvair 580 · Flushing, NYMar 18, 1977 · N5812 · Substantial damage NTSB ANC76AA075Accident · No injuriesClosedLockheed 188 · Udrivik Lake, AKMar 12, 1976 · N401FA · Destroyed NTSB MKC73IK072Incident · No injuriesClosedConvair 580 · Minneapolis, MNMay 31, 1973 · N968N · Minor damage NTSB CHI70IC047Incident · No injuriesClosedConvair 580 · Houghton, MIFeb 1, 1970 · N968N · Minor damage NTSB DCA66A0006Accident · 83 fatalClosedLockheed L-188C · Ardmore, OKApr 22, 1966 · N183H · Destroyed NTSB UNK64X3979Accident · No injuriesClosedConvair CV-440 · Farmington, NMSep 14, 1964 · N73126 · Substantial damage NTSB UNK64X1647Incident · No injuriesClosedConvair 340 · Salt Lake City, UTMay 7, 1964 · N73104 · Minor damage