Final NTSB investigations: North American P-51D
18 cases on aircraft the registry lists as North American 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 |
|---|---|
| 1965 | 2 |
| 1968 | 2 |
| 1971 | 1 |
| 1973 | 1 |
| 1974 | 1 |
| 1975 | 1 |
| 1980 | 1 |
| 1982 | 1 |
| 1985 | 1 |
| 1990 | 1 |
| 1994 | 1 |
| 2005 | 1 |
| 2007 | 1 |
| 2008 | 1 |
| 2013 | 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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('6402319', '05627Z2'))
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.aircraft_model_code IN ('6402319', '05627Z2'))
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 CEN14LA015Accident · 2 fatalLimited investigationFinal reportNorth American P 51D · Galveston, TXThe pilot's loss of situational awareness while instructing the passenger, which resulted in the controlled flight of the airplane into the water.NTSB DFW08CA202Accident · No injuriesData collectionFinal reportNorth American P-51D · Tulsa, OKThe pilot's failure to maintain aircraft control during takeoff.NTSB CHI07FA243Accident · 1 fatalField investigationFinal reportBeck P-51A · Oshkosh, WIThe P-51A pilot's inadequate visual lookout and his failure to maintain clearance from the P-51D. Contributing factors to the accident included the restricted forward visibility of the P-51A, the air race team representative's inadequate flight brief, the…NTSB CHI05LA177Accident · Serious injuriesLimited investigationFinal reportNorth American P-51D · Tarkio, MOA loss of engine power due to undetermined reasons and the unsuitable terrain encountered during the forced landing.NTSB LAX94LA361Accident · 1 fatalLimited investigationFinal reportNorth American P-51D · Reno, NVthe pilot's failure to maintain aircraft control during an attempted forced landing. Factors in the accident were the failure of a propeller blade-feathering oil seal which leaked oil on the windshield, obscuring the pilot's vision.NTSB NYC90DNA05Accident · 2 fatalFinal reportNorth American P-51D · Chatham, MAThe pilot's failure to maintain flying speed which resulted in an accelerated stall and loss of airplane control.NTSB LAX85LA392Accident · No injuriesLimited investigationFinal reportNorth American P-51D · Reno, NVThe plt had completed a heat race as a participant in the Reno national championship air races and was landing in a gusty x-wind when the acft's left wing was lifted by the wind and the acft cartwheeled, resulting in substantial damage to the wings and to the…NTSB FTW83LA019Accident · No injuriesLimited investigationFinal reportNorth American F-51D · Piedmont, OKThe eng failed at 5,500 ft MSL. During an emergency landing at a 5,000 ft dirt strip (under construction for paving), gear extension was delayed to increase glide. The right gear did not have time to lock down & retracted during landing. Initial exam of the…NTSB LAX81FUQ01Accident · 2 fatalClosedNo.American P-510 · Lancaster, CANTSB FTW76FQG32Accident · 2 fatalClosedN.American P-51D · Carlsbad, TXNTSB OAK75FVM12Accident · No injuriesClosedN.American F-51D · Hf Moon Bay, CANTSB MIA73FKG68Accident · 2 fatalClosedN.American P-51D · Atlanta, GANTSB MIA71FKG87Accident · No injuriesClosedN.American P-51 · Atlanta, GANTSB MIA69F0111Accident · Minor injuriesClosedN American F-51D · Sarasota, FLNTSB CHI68F0740Accident · Serious injuriesClosedN.American P-51D · Springfield, ILNTSB DEN66D0099Accident · No injuriesClosedN American P-51D · Grand Junctn, CONTSB OAK66F0057Accident · No injuriesClosedNo American P51-D · Fresno, CANTSB UNK64X3568Accident · 2 fatalClosedN American F-51D · Torrance, CA