Final NTSB investigations: Boeing 727-235
14 cases on aircraft the registry lists as Boeing 727-235. 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
| 1969 | 1 |
|---|---|
| 1970 | 1 |
| 1971 | 2 |
| 1972 | 2 |
| 1973 | 1 |
| 1974 | 1 |
| 1978 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1982 | 2 |
| 1986 | 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 ('138408B'))
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 ('138408B'))
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 DCA87MA010Accident · 1 fatalClass 1 · MajorFinal reportPiper PA-23-150 · Tampa, FLAt aprx 0612 EST, an eastern airline capt (owner of Piper PA-23, N2185P) departed a rwy near his home in VFR conds to commute to work at Tampa, FL. Shortly after takeoff, he contacted a fss & updated the wx info he had obtained on the previous evening. At…NTSB DCA82AA028Accident · 153 fatalFinal reportBoeing 727-235 · New Orleans, LAThe Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-83-02. To obtain a copy of this report, or to view the executive summary online, please see the Web site at http://www.ntsb.gov/publictn/publictn.htm The…NTSB MIA82FA051Accident · Serious injuriesField investigationFinal reportBoeing 727-235 · Miami, FLDuring takeoff roll a loud bang was heard & the takeoff aborted. The tower advised the flt of extensive fire in the tailarea. The plt cleared the active rwy & the acft was evacuated. 1 pax suffered a fractured ankle & another a sprained ankle. An explosion…NTSB MIA81AA106Accident · Minor injuriesClosedBoeing 727 · Ft.Lauderdale, FLNTSB ATL80IA067Incident · Minor injuriesClosedBoeing 727 · Richmond, VANTSB MIA78IA036Incident · No injuriesClosedBoeing 727 · Orlando, FLNTSB FTW74IF077Incident · No injuriesClosedBoeing 727 · Sierra Blanca, TXNTSB NYC74IN013Incident · No injuriesClosedBoeing 727 · Jamaica, NYNTSB FTW73IF005Incident · No injuriesClosedBoeing 727 · New Orleans, LANTSB MIA72IM116Incident · No injuriesClosedBoeing 727 · Jacksonville, FLNTSB NYC71IN102Incident · No injuriesClosedBoeing 727 · Jamaica, NYNTSB FTW71AF044Accident · Serious injuriesClosedBoeing 727 · St.Petersburg, FLNTSB MIA71IM008Incident · No injuriesClosedBoeing 727 · Jacksonville, FLNTSB MIA69I0077Incident · No injuriesClosedBoeing 727 · Pensacola, FL