NTSB investigations: Boeing 75
14 cases on aircraft the registry lists as Boeing 75. 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
| 1968 | 1 |
|---|---|
| 1971 | 2 |
| 1972 | 1 |
| 1974 | 1 |
| 1975 | 1 |
| 1976 | 1 |
| 1977 | 2 |
| 1978 | 1 |
| 1979 | 1 |
| 1984 | 1 |
| 1990 | 1 |
| 2006 | 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 ('1380104'))
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 ('1380104'))
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 DFW07CA003Accident · No injuriesData collectionFinal reportBoeing 75 · Sweetwater, TXThe pilot's failure to maintain directional control while landing.NTSB FTW90DPA04Accident · No injuriesFinal reportBoeing A75N1 · Longview, TXThe pilot's abrupt use of the wheel brakes during the landing roll.NTSB ATL85LA032Accident · No injuriesLimited investigationFinal reportBoeing 75 · Rustburgh, VAThe pilot stated that he was landing on the 1,100 foot long runway to the south with a 16 knot tailwind. The plt continued to state that while on final apch the aircraft had an excessive rate of sink. The plt added full power in an attempt to arrest the…NTSB MIA79DLD78Accident · No injuriesClosedBoeing A75 · Summerfield, FLNTSB OAK78DVD37Accident · No injuriesClosedBoeing A75N1 · Tracy, CANTSB OAK78FVA11Accident · Serious injuriesClosedBoeing A75 · Planada, CANTSB OAK77FVD27Accident · No injuriesClosedBoeing A75 · Tracy, CANTSB MIA76DL061Accident · No injuriesClosedBoeing A75N1 · Summerfield, FLNTSB MIA76DLD29Accident · No injuriesClosedBoeing A75N1 · Lake Placid, FLNTSB MIA75DLD23Accident · No injuriesClosedBoeing A75N1 · Lake Placid, FLNTSB MIA72FLA47Accident · Minor injuriesClosedBoeing A75N1 · Obrien, FLNTSB MKC72FCA04Accident · No injuriesClosedBoeing E75N1 · St.Charles, MONTSB MIA71DLA44Accident · No injuriesClosedBoeing A75 · Hastings, FLNTSB FTW69D0227Accident · No injuriesClosedBoeing E75 · Stowell, TX