NTSB investigations: Boeing A75N1(PT17)
10 cases on aircraft the registry lists as Boeing A75N1(PT17), where the first occurrence was “Loss of control - in flight”. 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
| 1985 | 3 |
|---|---|
| 1987 | 1 |
| 1990 | 1 |
| 1993 | 1 |
| 1994 | 2 |
| 2001 | 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 ('1380134')
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\" = 250))
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 ('1380134')
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" = 250))
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 NYC07LA124Accident · 2 fatalLimited investigationFinal reportBoeing Stearman A75N1 · Charleston, SCAn in-flight collision with water for undetermined reasons.NTSB ATL01FA093Accident · 2 fatalField investigationFinal reportBoeing Stearman PT-17 · Anniston, ALThe inadvertent activation of the flight control gust locks by the pilot rated passenger that resulted in the loss of control inflight. Contributing was the pilot in commands failure to follow the airplane's pre-flight inspection check list.NTSB NYC95LA021Accident · 2 fatalLimited investigationFinal reportBoeing A-75N1 · Sayville, NYA loss of control in flight by the pilot(s) while maneuvering, with insufficient altitude for recovery.NTSB MIA94LA055Accident · Serious injuriesLimited investigationFinal reportBoeing A75N1 · Zellwood, FLInadvertent stall/spin by the pilot-in-command while executing a spiral to landing maneuver during the base to final turn.NTSB NYC93FA127Accident · 2 fatalField investigationFinal reportBoeing Stearman PT-17 · Concord, NHLoss of airplane control as the result of incapacitation.NTSB CHI90FA212Accident · 1 fatalField investigationFinal reportBoeing A75N1 · Oshkosh, WIThe pilot-in-command's failure to maintain airspeed sufficient to avoid a stall/spin at an altitude insufficient to effect a full recovery.NTSB DEN87LA101Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · Argusville, NDThe plt took off with a load of 46-0-0 fertilizer and proceeded to the field to be treated. The plt said when he arrived his flagger was not in position so he initiated a goaround. When the plt had turned 90 deg onto the x-wind leg the acft stalled. The plt…NTSB LAX86FA014Accident · 1 fatalField investigationFinal reportBoeing A75N1 · Schellville, CAThe acft crashed while attempting a slow roll immediately after departing from rwy 34 at the sonoma valley arpt. The plt stated to witnesses that he liked to roll his acft after takeoff. Witnesses indicated the acft became airborne after a 300 to 400 ft…NTSB CHI85LA239Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Deckerville, MIPurpose of the flt was a 'flour bombing contest'. After dropping a 'flour bomb' the plt entered a right bank to avoid trees along the flt path. The acft then stalled and impacted the ground on the main gear after which it nosed over.NTSB CHI85LA188Accident · No injuriesLimited investigationFinal reportStearman PT 17 · Hamilton, OHThe pilot was taking off in a 90 degree cross wind of 15 KTS gusts 23 KTS immediatly after liftoff a gust of wind resulted in pilot loss of directional control the acft veered off of the runway struck a ditch and nosed over inverted.