Fatal NTSB investigations: North American/Aero Classics P-51D
11 cases on aircraft the registry lists as North American/Aero Classics P-51D. 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
| 1964 | 1 |
|---|---|
| 1979 | 1 |
| 1984 | 1 |
| 1987 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 2010 | 1 |
| 2011 | 1 |
| 2014 | 1 |
| 2017 | 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('6402304'))
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."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('6402304'))
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 CEN19FA028Accident · 2 fatalField investigationFinal reportNorth American P51 · Fredericksburg, TXThe pilot's decision to perform a low-level maneuver at an altitude where he was unable to recover the airplane before impacting terrain.NTSB CEN17FA270Accident · 2 fatalField investigationFinal reportNorth American/Aero Classics P 51 · Cummings, KSThe loss of airplane control while maneuvering at low altitude for reasons that could not be determined.NTSB CEN14FA339Accident · 2 fatalField investigationFinal reportNorth American/Aero Classics P 51D · Durango, COThe pilot's failure to compensate for the high-performance airplane's tendency to enter a torque roll during the initial climb, which resulted in the airplane entering a torque roll and the subsequent loss of control at too low of an altitude to recover.…NTSB WPR11MA454Accident · 11 fatalClass 1 · MajorFinal reportNorth American/Aero Classics P-51D · Reno, NVThe reduced stiffness of the elevator trim tab system that allowed aerodynamic flutter to occur at racing speeds. The reduced stiffness was a result of deteriorated locknut inserts that allowed the trim tab attachment screws to become loose and to initiate…NTSB WPR10LA156Accident · 1 fatalLimited investigationFinal reportNorth American P51D · Chandler, AZThe pilot’s improper flare, resulting in a bounced landing, stall, and loss of directional control.NTSB CHI97LA284Accident · 2 fatalLimited investigationFinal reportNorth American-Aero Classics P-51D · Monroe, MIthe pilot operating the airplane with a known coolant leak, coolant exhaustion, overheating of the engine, and subsequent failure of a connecting rod, which resulted in a partial loss of engine power; and failure of the pilot to see the powerline. The…NTSB NYC95LA138Accident · 1 fatalLimited investigationFinal reportNorth American F-51D · Malone, NYthe pilot's improper use of the flight controls, which resulted in an accelerated stall, an in-flight loss of control, and an uncontrolled descent to the ground. A factor relating to the accident was: the pilot's decision to fly the airplane in an airshow…NTSB CHI87DEM09Accident · 2 fatalFinal reportNorth American P-51D · Ludington, MIN3278D was #1 (leader) in a flt of 2 North American P-51 acft. The plt of the 2nd P-51 rprtd that they were on a southerly heading over water about 1/2 mi from the shore when the leader raised his nose & began rolling to the right. Witnesses on the beach…NTSB DEN84FA222Accident · 2 fatalField investigationFinal reportNorth American P-51D · Carbondale, COThe plt was performing aerobatic maneuvers in a P-51D that had been modified for racing & exhibition. Witnesses near the accident site stated that the acft had just completed several aerobatic maneuvers before it began a vertical climb. The climb was…NTSB MIA80FA019Accident · 2 fatalClosedN American P-51D · Eufaula, ALNTSB UNK64X2311Accident · 5 fatalClosedN.American F-51D · Roseburg, OR