NTSB investigations: Boeing 727-225, FL
5 cases on aircraft the registry lists as Boeing 727-225. 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
| 1981 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1990 | 1 |
| 1992 | 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.aircraft_model_code IN ('1384077'))
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.aircraft_model_code IN ('1384077'))
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 MIA93IA030Incident · Minor injuriesIncident investigationFinal reportBoeing 727-225A · Miami, FLThe failure of the window pane for undetermined reasons.NTSB MIA90IA070Incident · No injuriesIncident investigationFinal reportBoeing 727-225A · Sarasota, FLImproper servicing of the forward lavatory by contract service personnel.NTSB MIA84IA063Incident · No injuriesIncident investigationFinal reportBoeing 727-225A · Tampa, FLThe acft experienced a rapid loss of fuel quanity on the #1 fuel tank during the climb to cruise. Investigation revealed that prior to this flt the water separator access door had been replaced by a fabricated metal plate which separated in flt. The separated…NTSB MIA83IA075Incident · No injuriesIncident investigationFinal reportBoeing B-727-200 · Miami, FLDuring gear retraction after takeoff, the aircrew noted that the left main landing gear (MLG) door warning light remained illuminated. The landing gear control was cycled, but the condition was not corrected. Attempts to extend the left MLG were also…NTSB MIA81IA063Incident · No injuriesClosedBoeing 727 · Miami, FL