NTSB investigations: North American F-51D, 1982
2 cases on aircraft the registry lists as North American F-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 | 3 |
|---|---|
| 1965 | 3 |
| 1966 | 3 |
| 1967 | 6 |
| 1968 | 1 |
| 1969 | 1 |
| 1972 | 2 |
| 1973 | 1 |
| 1974 | 2 |
| 1976 | 2 |
| 1978 | 1 |
| 1979 | 1 |
| 1981 | 1 |
| 1982 | 2 |
| 1989 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 2005 | 1 |
| 2007 | 1 |
| 2016 | 1 |
| 2026 | 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 year(c.\"eventDate\") = 1982
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('6402309', '6402310'))
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 year(c."eventDate") = 1982
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('6402309', '6402310'))
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 LAX82DA349Accident · No injuriesFinal reportNorth American P-51D · Reno, NVThe engine failed & caught fire during the national championship air races. The plt stated he was pre-occupied trying toput out the engine fire & turned base too late. The acft landed short of the rwy on a poorly graded road & the plt lost control of the acft.NTSB LAX82DXQ13Accident · 2 fatalFinal reportNorth American F-51D · Elko, NVThe plt flew down the length of rwy 06 about 100 ft AGL, pulled up & did an 8-point roll while climbing. He then flew down rwy 12 & pulled up. After a brief climb the plt began a slow roll to the left. Just as the acft became inverted the roll stopped & the…