NTSB investigations: Boeing 747-121
15 cases on aircraft the registry lists as Boeing 747-121. 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
| 1970 | 3 |
|---|---|
| 1971 | 3 |
| 1972 | 1 |
| 1977 | 2 |
| 1979 | 1 |
| 1983 | 1 |
| 1988 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1995 | 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.aircraft_model_code IN ('138487A', '1384871'))
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.aircraft_model_code IN ('138487A', '1384871'))
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 MIA96FA013Accident · No injuriesField investigationFinal reportBoeing 747-121 · Miami, FLfailure of the No. 4 engine fifth stage turbine hub due to a cyclic stress rupture for undetermined reasons, which resulted in an uncontained failure of the engine.NTSB DCA93MA033Accident · No injuriesClass 1 · MajorFinal reportBoeing 747-121 · Anchorage, AKThe lateral separation of the no. 2 engine pylon due to an encounter with severe or possibly extreme turbulence that resulted in dynamic multi-axis lateral loadings that exceeded the ultimate lateral load-carrying capability of the pylon, which was already…NTSB BFO92IA046Incident · No injuriesIncident investigationFinal reportBoeing 747-123 · Louisville, KYInadequate obstacle clearance, which resulted in on ground collision with a blast fence. Contributing was inadequate instruction from ground personnel.NTSB DCA89RA014Accident · 270 fatalForeign investigationBoeing 747-121 · Lockerbie, United KingdomNTSB DCA83RA001Accident · No injuriesForeign investigationBoeing 747-121 · PakistanNTSB LAX79IA092Incident · 1 fatalClosedBoeing 747 · Pacific Ocean (Pacific Ocean)NTSB DCA77RA014Accident · 574 fatalClosedBoeing 747 · Tenerife, SPNTSB NYC77IA041Incident · No injuriesClosedBoeing 747 · London, United KingdomNTSB DCA72RZ014Accident · No injuriesClosedBoeing 747 · London, United KingdomNTSB LAX72IL014Incident · No injuriesClosedBoeing 747 · Los Angeles, CANTSB DCA72AZ002Accident · Serious injuriesClosedBoeing 747 · San Frncsco, CANTSB NYC71AN088Accident · Serious injuriesClosedBoeing 747 · Wilmington, NCNTSB NYC71AN054Accident · Serious injuriesClosedBoeing 747 · Nantucket, MANTSB SEA70IS044Incident · No injuriesClosedBoeing 747 · Moses Lake, WANTSB NYC70IN085Incident · No injuriesClosedBoeing 747 · N.Atlantic Ocean (Atlantic Ocean)