NTSB investigations: Boeing E75, FL
10 cases on aircraft the registry lists as Boeing E75. 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
| 1972 | 3 |
|---|---|
| 1973 | 1 |
| 1974 | 1 |
| 1977 | 1 |
| 1981 | 1 |
| 1987 | 1 |
| 1993 | 1 |
| 2002 | 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 ('1380120'))
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 ('1380120'))
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 MIA02LA150Accident · Minor injuriesLimited investigationFinal reportBoeing E75 · Leesburg, FLLoss of engine power for undetermined reasons during takeoff, resulting in the airplane colliding with the ground and nosing over during the subsequent forced landing.NTSB MIA93LA199Accident · Minor injuriesLimited investigationFinal reportBoeing E75 · Deland, FLFailure of both pilots to maintain adequate visual lookout. Factors related to the accident were: the conflicting right traffic pattern procedures for landing that were briefed to the Boeing E75 pilot by the owner of the airstrip, and failure of both pilots…NTSB MIA87LA262Accident · Minor injuriesLimited investigationFinal reportBoeing E75 · Ocala, FLThe plt stated that the eng lost power & he was at low alt looking for an emerg ldg field when the wing hit a tree. The pax stated they were doing aerobatics at low alt & the eng quit. She stated that she was not wearing the required parachute & had asked the…NTSB MIA81DKT92Accident · No injuriesClosedBoeing E-75 · Opalocka, FLNTSB MIA77FLD73Accident · 1 fatalClosedBoeing E-75 · Ft.Pierce, FLNTSB MIA74DLD86Accident · No injuriesClosedBoeing E75 · Avon Park, FLNTSB MIA73FLA43Accident · 1 fatalClosedBoeing E75 · Trenton, FLNTSB MIA73FKT39Accident · 1 fatalClosedBoeing E75 · Clewiston, FLNTSB MIA73DLA12Accident · No injuriesClosedBoeing E75 · Green Cove Sp, FLNTSB MIA72DKT52Accident · No injuriesClosedBoeing A75 · Belle Glade, FL