NTSB investigations: Boeing B75N1
10 cases on aircraft the registry lists as Boeing B75N1, 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
| 1983 | 1 |
|---|---|
| 1986 | 1 |
| 1987 | 1 |
| 1993 | 2 |
| 1994 | 1 |
| 1995 | 1 |
| 1997 | 2 |
| 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 ('1380144')
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 ('1380144')
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 CHI06CA238Accident · No injuriesData collectionFinal reportBoeing B75N1 · Minerva, OHThe pilot's failure to maintain directional control during landing which resulted in the airplane striking a dirt mound and nosing over. The dirt mound was a factor.NTSB CHI97LA242Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Lone Rock, WIa locked right brake which resulted in the pilot's inability to maintain direction control of the airplane during the landing roll.NTSB LAX97LA130Accident · No injuriesLimited investigationFinal reportBoeing Stearman B75N1 · Victorville, CAfailure of the pilot to maintain directional control of the aircraft during the landing rollout.NTSB FTW95LA341Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Englewood, COFailure by the pilot to maintain directional control which resulted in a ground loop. A factor was crosswind.NTSB CHI94LA150Accident · No injuriesLimited investigationFinal reportBoeing B75-N1 · Sandwich, ILthe pilot in command's failure to maintain directional control during a crosswind landing and attempted go around.NTSB FTW93LA221Accident · No injuriesLimited investigationFinal reportBoeing B75-N1 · Burnet, TXInadvertent groundloop by the pilot.NTSB LAX93LA238Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Pacoima, CAA failure of the pilot to adequately compensate for cross wind conditions and a failure to maintain directional control of the airplane.NTSB DEN87LA129Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Mandan, NDThe pilot and his son were ferrying a recently purchased Boeing stearman to their home in Ohio. During landing roll, at an en route stop, a gust of wind lifted the tail section and the acft groundlooped. The left wing struck the runway and the acft was…NTSB ATL87LA014Accident · No injuriesLimited investigationFinal reportBoeing B-75-N1 · Columbus, OHDuring a landing attempt on asphalt surfaced runway 23, the pilot reported that the aircraft swerved to the left upon touchdown. Right alleron and rudder was applied to stop the turn. Wheel brakes were applied and the aircraft nosed over on the side of the…NTSB CHI83LA421Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Galesburg, ILThe plt stated that when he was landing on rwy 20 with a x-wind, it switched to a rear quartering wind. At about that time, the acft went off the rwy & struck a rwy marker with its tailwheel. The acft then ground looped, damaging the lower left wing.