Final NTSB investigations: Boeing B75
12 cases on aircraft the registry lists as Boeing B75. 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
| 1964 | 1 |
|---|---|
| 1966 | 1 |
| 1967 | 1 |
| 1968 | 1 |
| 1975 | 1 |
| 1976 | 1 |
| 1978 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 2016 | 1 |
| 2020 | 1 |
| 2023 | 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 ('1380116'))
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 ('1380116'))
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 ERA23LA381Accident · No injuriesClass 4 · LimitedFinal reportBoeing B75 · Erwinna, PAThe pilot’s failure to maintain control of the airplane while taking off in a crosswind.NTSB WPR20LA226Accident · No injuriesClass 3 · LimitedFinal reportBoeing B75 · Chino, CAThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA16CA249Accident · No injuriesData collectionFinal reportBoeing B75 · El Cajon, CAThe pilot's failure to maintain directional control during the landing roll in gusty crosswind conditions, which resulted in a runway excursion and nose over.NTSB FTW82DRJ19Accident · No injuriesFinal reportBoeing B-75 · Lufkin, TXN733BD was holding for the active runway when N59257 taxied into the tail of the aircraft. N733BD received substantial damage and N59257 received minor damage.NTSB CHI81FA058Accident · 1 fatalClosedBoeing A75 · Wellington, OHNTSB NYC78FHA34Accident · No injuriesClosedStearman PT-17 · Pottstown, PANTSB FTW76DRA47Accident · No injuriesClosedBoeing A75 · Fresno, TXNTSB LAX76DVA20Accident · No injuriesClosedBoeing B75 · Kettleman City, CANTSB FTW68F0487Accident · Serious injuriesClosedBoeing B75 · Houston, TXNTSB FTW68A0003Accident · 1 fatalClosedBoeing IB75A · Ganado, TXNTSB OAK67A0021Accident · 1 fatalClosedBoeing B75 · Farmersvlle, CANTSB UNK64X3521Accident · No injuriesClosedBoeing B75 · Palacios, TX