NTSB investigations: Boeing E75
13 cases on aircraft the registry lists as Boeing E75, where the first occurrence was “Loss of control - on ground/water”. 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
| 1982 | 2 |
|---|---|
| 1983 | 1 |
| 1985 | 1 |
| 1988 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 2000 | 2 |
| 2003 | 1 |
| 2007 | 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 ('1380120')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
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 ('1380120')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260))
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 CHI07CA297Accident · No injuriesData collectionFinal reportBoeing Stearman E75 · Gordon, NEThe pilot's failure to maintain directional control during the crosswind landing which resulted in the inadvertent ground loop.NTSB LAX03LA195Accident · No injuriesLimited investigationFinal reportBoeing Stearman E75 · Casa Grande, AZThe pilot's inadequate compensation for the wind conditions, and his failure to maintain aircraft control resulting in an inadvertent ground loop.NTSB SEA00LA195Accident · No injuriesLimited investigationFinal reportBoeing E75 · Salem, ORThe pilot's failure to maintain aircraft control upon experiencing a loss of normal braking effectiveness. Factors included a partial failure of the brake system, a tailwind, and a parked aircraft.NTSB SEA00LA159Accident · No injuriesLimited investigationFinal reportBoeing E75 · Mcminnville, ORThe disconnection of the left tailwheel control cable spring resulting in the positioning of the tailwheel in a right turn condition.NTSB FTW96LA211Accident · No injuriesLimited investigationFinal reportBoeing E75 · Taos, NMthe pilot's failure to maintain directional control. A factor was the dust devil.NTSB NYC95LA010Accident · No injuriesLimited investigationFinal reportBoeing Stearman PT-17 · Fitchburg, MAThe pilot's failure to adequately compensate for the crosswind condition during landing, which resulted in a ground loop and the subsequent wing tip collision with the runway.NTSB LAX92LA195Accident · No injuriesLimited investigationFinal reportBoeing PT-17 · Chino, CAThe pilot's failure to maintain directional control during the landing roll out.NTSB LAX91LA283Accident · No injuriesLimited investigationFinal reportBoeing E75 · San Luis Obispo, CAThat the pilot failed to properly compensate of the existing quartering tailwind, improperly using the flight controls and brakes.NTSB FTW88DRG08Accident · No injuriesFinal reportBoeing Stearman E-75 · Fisher, TXAfter touchdown, the pilot stated that he lost directional control and the right main gear ran off the right side of the runway. During attempted recovery, the airplane rolled off the left side of the runway, collided with a drainage ditch and nosed over to…NTSB CHI85LA224Accident · No injuriesLimited investigationFinal reportStearman E-75 · Lake Odessa, MIUpon landing the aircraft veered to the right. Power & left rudder were applied, however, the aircraft continued to the right. Power was reduced but the aircraft continued to the right. The aircraft nosed over after coming in contact with a soft, plowed…NTSB CHI83LA302Accident · No injuriesLimited investigationFinal reportBoeing B75 · Cincinnati, OHThe acft collided with a ditch during landing roll and nosed down. The weather was VMC with the wind from 020 degrees AT6 KTS. The plt landed on rwy 24. About 1500 ft from the threshold the acft veered off the rwy and hit the ditch. The pltattributed the loss…NTSB FTW82DA341Accident · No injuriesFinal reportBoeing E75 · Monahans, TXPilot lost control of aircraft during landing and groundlooped.NTSB CHI82DA225Accident · No injuriesFinal reportBoeing E75 · Bloomington, ILThe pilot stated that almost immediately after touchdown the aircraft began tracking to the left. During the attempt to arrest the swerve, the aircraft ground looped 180 degrees to the right. The tail struck two taxi lights as it rotated and the aircraft came…