Final NTSB investigations: Boeing 727-247
10 cases on aircraft the registry lists as Boeing 727-247. 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
| 1976 | 2 |
|---|---|
| 1978 | 1 |
| 1979 | 2 |
| 1983 | 1 |
| 1989 | 1 |
| 1995 | 1 |
| 1997 | 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 ('138408F'))
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 ('138408F'))
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 NYC00IA100Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-88 · Boston, MAthe failure of the ground pushback crew to maintain an adequate clearance from a nearby airplane during pushback.NTSB FTW97FA255Accident · Minor injuriesField investigationFinal reportBoeing 727-247 · Albuquerque, NMThe inadequate inspection of the right main landing gear forward trunnion bearing support fitting. Factors were the failure of the right main landing gear forward trunnion bearing support fitting and the subsequent right main landing gear failure.NTSB ATL95LA062Accident · Serious injuriesLimited investigationFinal reportBoeing 727-200 · Alma, GAThe aircraft's encounter with unforecast clear air turbulence.NTSB DEN89IA124Incident · No injuriesIncident investigationFinal reportBoeing 727-247 · Denver, COFailure of the left main landing gear forward trunnion bearing support fitting due to a crack initiating at the forward edge of the bore and propagating by intergranular stress corrosion into the bore surface that resulted in an eventual ductile fracture.NTSB SEA83LA039Accident · Serious injuriesLimited investigationFinal reportBoeing 727 · Near Yakima, WADuring a climb to cruise, one passenger was injured when turbulence was encountered at about 20,500 ft MSL. The injured passenger was a 73 year old male, a retired priest and the only passenger not seated and wearing a seatbelt. As he exited the restroom, the…NTSB MKC79IA021Incident · No injuriesClosedBoeing B727 · Minneapolis, MNNTSB LAX79IA023Incident · No injuriesClosedBoeing 727 · Los Angeles, CANTSB LAX78IA056Incident · Minor injuriesClosedBoeing 727 · Los Angeles, CANTSB MKC76AK063Accident · Serious injuriesClosedBoeing 727 · Minneapolis, MNNTSB LAX76AL045Accident · Serious injuriesClosedBoeing 727 · Los Angeles, CA