NTSB investigations: Boeing 727-227
8 cases on aircraft the registry lists as Boeing 727-227. 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
| 1979 | 1 |
|---|---|
| 1985 | 1 |
| 1988 | 2 |
| 1993 | 3 |
| 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 ('1384078'))
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 ('1384078'))
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 MIA95IA134Incident · Serious injuriesIncident investigationFinal reportBoeing 727-227 · Brooksville, FLAn elderly passenger losing his balance as the aircraft operated in smooth air.NTSB CHI94FA039Accident · No injuriesField investigationFinal reportBoeing 727-227 · Chicago, ILThe captain's failure to assure that the landing gear was extended for landing. Factors related to the accident were: traffic alert distractions, the flight crew's failure to use the checklist, and inadequate company systems training.NTSB FTW93FA100Accident · Serious injuriesField investigationFinal reportBoeing 727-200 · Houston, TXThe failure of the pilot of the T-38A to follow flight advisories. A factor which contributed to the accident was the development of a letter of agreement between the FAA and NASA which was not in accordance with ICAO procedures.NTSB NYC93IA064Incident · No injuriesIncident investigationFinal reportBoeing 727-200 · Newark, NJThe pilot's disorientation while taxiing, resulting in a runway incursion. Factors contributing to the incident were: the failure of the flight crew to communicate with the ATC ground controller to verify their position; the inadequate crew coordination; and…NTSB SEA88IA108Incident · Minor injuriesIncident investigationFinal reportBoeing 727-200 · Seattle, WAAfter the main gear touched down, thrust levers were placed in the idle reverse position. Once the aircraft's nose gear contacted the runway, braking and full reverse thrust was applied. The aircraft started to drift to the left of the runway centerline. The…NTSB MIA88IA176Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-300 · Near San Juan, PRPan am flt 217 (Airbus A300, N209PA) was clrd by new york center oceanic ctl area (oca) to proceed south on airway amber 300 at FL 290 over the atlantic ocean. As it was en route, American flt 902 departed san Juan (sju), PR for a northbound flt on the same…NTSB LAX85IA206Incident · No injuriesIncident investigationFinal reportBoeing 727-227 · Las Cruces, NMWhile cruising at flt level 350 in clear smooth air, a loud noise was heard, accompanied by a severe jolt on the right side of the cabin, as the number 3 end separated from its mounts. Subsequent investigation disclosed that the forward lavatory was leaking…NTSB DEN79IA045Incident · No injuriesClosedBoeing 727 · Denver, CO