NTSB investigations: Rolls-Royce V-1650-7
13 cases on aircraft whose registry engine model is Rolls-Royce V-1650-7. 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
| 1968 | 1 |
|---|---|
| 1982 | 1 |
| 1984 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1994 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2007 | 1 |
| 2008 | 1 |
| 2010 | 1 |
| 2016 | 1 |
| 2017 | 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.engine_model_code IN ('54558'))
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.engine_model_code IN ('54558'))
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 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 GAA16CA133Accident · Minor injuriesData collectionFinal reportNorth American P 51 · Dallas, TXThe pilot's failure to extend the landing gear prior to landing, which resulted in substantial damage to the fuselage during landing.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 DFW08CA202Accident · No injuriesData collectionFinal reportNorth American P-51D · Tulsa, OKThe pilot's failure to maintain aircraft control during takeoff.NTSB SEA07LA196Accident · 1 fatalLimited investigationFinal reportNorth American F-51D · Camarillo, CAThe pilot's failure to maintain aircraft control during a go-around. Contributing to the accident was the pilot's lack of experience in the make and model of airplane.NTSB LAX06CA047Accident · No injuriesData collectionFinal reportNorth American P-51D · Minden, NVthe pilot's failure to maintain directional control on landing.NTSB CHI04LA128Accident · 1 fatalLimited investigationFinal reportNorth American P-51C · Hager City, WIThe improper installation of the camshaft drive gear assembly which resulted in the retaining nut backing off allowing the drive gear to move up the shaft. A factor associated with the accident was the low altitude at which the power loss occurred and the…NTSB CHI95LA064Accident · Minor injuriesLimited investigationFinal reportNorth American F-51D · Round Lake, ILfuel starvation resulting from exhaustion of the fuel supply in the left tank. A factor related to the accident was insufficient altitude to switch fuel tanks and effect an engine restart.NTSB CHI90DER02Accident · 2 fatalFinal reportNorth American P-51D · Mayer, MNUndeterminedNTSB CHI89DET03Accident · No injuriesFinal reportNorth American F-51D · Fort Wayne, INPilot's failure to maintain aircraft control during the crosswind takeoff. Contributing to the accident was the premature lift off and the crosswind condition.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 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 MIA69F0111Accident · Minor injuriesClosedN American F-51D · Sarasota, FL