Final NTSB investigations: Boeing 747-251F
5 cases on aircraft the registry lists as Boeing 747-251F. 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
| 1977 | 1 |
|---|---|
| 1979 | 1 |
| 1988 | 1 |
| 1993 | 1 |
| 2000 | 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 ('1384898'))
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 ('1384898'))
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 ANC01IA007Incident · No injuriesIncident investigationFinal reportBoeing 747-251F · Anchorage, AKRupture and disintegration of main landing gear tires during the takeoff roll, and subsequent damage to the right main gear hydraulic brake system.NTSB ANC93IA188Incident · No injuriesIncident investigationFinal reportBoeing 747-200 · Anchorage, AKForeign object damage to the compressor forward fan assembly as a result of the ingestion of a bird.NTSB CHI88IA040Incident · No injuriesIncident investigationFinal reportBoeing 747-251F · Minneapolis, MNAircraft experienced a loss of aileron ctl when ice formed around aileron control cables and restricted their movement. Water draining through open plenum drains in the main landing gear wheel well froze when exposed to below freezing temperatures at 35,000…NTSB UNK79X0111Accident · No injuriesClosedBoeing 747 · Frankfurt, GeorgiaNTSB NYC78FA008Accident · No injuriesClosedBoeing 747F · Jamaica, NY