NTSB investigations: North American/Aero Classics P-51D
30 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 | 2 |
|---|---|
| 1965 | 1 |
| 1967 | 1 |
| 1968 | 1 |
| 1970 | 3 |
| 1971 | 1 |
| 1973 | 1 |
| 1979 | 1 |
| 1981 | 1 |
| 1984 | 1 |
| 1987 | 2 |
| 1989 | 2 |
| 1990 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2010 | 1 |
| 2011 | 1 |
| 2014 | 1 |
| 2017 | 1 |
| 2018 | 1 |
| 2022 | 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.\"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."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 CEN23LA072Accident · No injuriesClass 4 · LimitedFinal reportPiper PA46 · Brookshire, TXThe P51 pilot’s failure to see and avoid the PA46 during taxi operations.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 LAX06CA047Accident · No injuriesData collectionFinal reportNorth American P-51D · Minden, NVthe pilot's failure to maintain directional control on landing.NTSB NYC04CA196Accident · No injuriesData collectionFinal reportWahl S-51D · Louisville, KYThe pilot's failure to maintain directional control on the runway during landing.NTSB SEA03LA202Accident · No injuriesLimited investigationFinal reportNorth American P-51D · Jerome, IDThe malfunction of the cooling system pressure relief valve and the pilot's failure to follow procedures. An engine over temperature, a coolant leak as a result of a relief valve failure, an obstructed windshield which was covered with coolant fluid, and an…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 LAX94LA178Accident · Minor injuriesLimited investigationFinal reportNorth American P-51D · Chino, CAthe pilot's decision to fly an unairworthy and uncertificated airplane, his failure to perform an adequate preflight, and the improper installation of the oil cooler lines.NTSB FTW90DRA02Accident · Serious injuriesFinal reportNorth American P-51-D · Galveston, TXThe pilot in command's failure to obtain a weather briefing. Ontributing to the accident was his inadequate inflight planning and the resultant low fuel state.NTSB LAX89FA295Accident · Serious injuriesField investigationFinal reportNorth American P51D · Mar Vista, CAThe pilot's poor in-flight planning in attempting to immediately return to the airport and not following established procedures after the loss of power after takeoff. The failure of an intake valve was a factor in the accident.NTSB LAX89LA173Accident · No injuriesLimited investigationFinal reportNorth American P-51D · Travis Afb, CAThe left main landing gear failing to fully extend for undetermined reasons resulting in its collapsing during landing.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 LAX87DVW01Accident · Minor injuriesFinal reportNorth American P51D · Ashfork, AZThe North American P-51D experienced a total loss of engine power after cruising at 10,000 feet MSL for 45 minutes. Attempts to restart the engine were unsuccessful. The aircraft collided with some trees prior to coming to rest in an open field. The landing…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 MKC81FCD20Accident · Minor injuriesClosedN American P-51D · Council Bluffs, IANTSB MIA80FA019Accident · 2 fatalClosedN American P-51D · Eufaula, ALNTSB FTW74FQG17Accident · No injuriesClosedN.American P-51D · Midland, TXNTSB LAX72FUG36Accident · Minor injuriesClosedN.American P-51D · Chino, CANTSB FTW71FRG39Accident · Serious injuriesClosedN.American P-51D · Rockport, TXNTSB OAK71FXQ16Accident · Minor injuriesClosedN.American P-51D · Reno, NVNTSB OAK71FVD05Accident · Serious injuriesClosedN.American P-51D · Concord, CANTSB DIA68F0188Accident · No injuriesClosedN American P-51D · Frederick, MDNTSB DIA68D0085Accident · No injuriesClosedN American P-51 · Frederick, MDNTSB FTW66F0331Accident · No injuriesClosedNo American P-51 · Brownwood, TXNTSB UNK64X2311Accident · 5 fatalClosedN.American F-51D · Roseburg, ORNTSB UNK64X0655Accident · No injuriesClosedNo American P51 · La Porte, IN