NTSB investigations: Pratt & Whitney R-2800 series, FL
12 cases on aircraft whose registry engine model is Pratt & Whitney R-2800 series. 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
| 1962 | 1 |
|---|---|
| 1967 | 1 |
| 1968 | 1 |
| 1972 | 1 |
| 1973 | 1 |
| 1975 | 1 |
| 1976 | 1 |
| 1979 | 2 |
| 1980 | 1 |
| 1997 | 1 |
| 2004 | 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.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52026'))
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."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52026'))
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 MIA05FA040Accident · No injuriesField investigationFinal reportConvair Div. of Gen. Dynamics 340 · N. Miami Beach, FLThe improper maintenance of the left engine by company maintenance personnel (failure to flush metal from the oil system and failure to properly preserve the engine for storage) resulting in a total failure of the master rod bearing and contamination of the…NTSB MIA97LA113Accident · No injuriesLimited investigationFinal reportChance Vought F4U · New Smyrna Bch, FLThe pilot's failure to assure that an adequate supply of fuel was on board for the intended flight.NTSB MIA80FA065Accident · 3 fatalClosedConvair 240 · Daytona Beach, FLNTSB MIA79FA089Accident · 2 fatalClosedLockheed PV-1 · Dania, FLNTSB MIA79FKT54Accident · No injuriesClosedLockheed PV-1 · Belle Glade, FLNTSB MIA76AM084Accident · No injuriesClosedCurtiss C-46F · Miami, FLNTSB MIA75IM088Incident · No injuriesClosedMartin 404 · Key West, FLNTSB MIA74AM037Accident · No injuriesClosedCurtis-Wrt C-46A · Lakeland, FLNTSB MIA73AM023Accident · No injuriesClosedMartin 404 · Ft.Lauderdale, FLNTSB MIA68A0066Accident · No injuriesClosedCurtiss WRT C-46 · Miami, FLNTSB MIA67A0130Accident · No injuriesClosedLockheed PV-2 · Kissimmee, FLNTSB MIA62A0034Accident · No injuriesClosedCurtiss WRT C-46A · Tyndall Afb, FL