NTSB investigations: Boeing A75N1(PT17)
12 cases on aircraft the registry lists as Boeing A75N1(PT17), where the first occurrence was “In flight collision with object”. 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 | 1 |
|---|---|
| 1983 | 2 |
| 1986 | 1 |
| 1987 | 1 |
| 1989 | 2 |
| 1992 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2001 | 1 |
| 2003 | 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\" = 220))
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" = 220))
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 IAD03CA057Accident · Minor injuriesData collectionFinal reportBoeing A75N1(PT17) · Sutton, WVThe pilot's failure to abort the takeoff in a timely manner. Factors included the high density altitude conditions, and the pilot's lack of familiarity with the airplane's high density altitude performance characteristics.NTSB DEN01LA159Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 (PT17) · Watkins, COthe pilot's failure to maintain clearance with the guy wire.NTSB IAD99LA050Accident · Serious injuriesLimited investigationFinal reportBoeing Stearman PT17 · Lock Haven, PAthe pilot's improper inflight decision to fly at an inadequate altitude and his improper visual lookout which resulted in a collision with wires.NTSB LAX98LA198Accident · Minor injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Riverbank, CAThe pilot's inadequate visual lookout for on-coming ground traffic.NTSB ATL92LA127Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · Dunn, NCThe pilot's inadequare visual lookout to see and avoid the 8 foot high pole adjacent to the landing strip.NTSB MIA89FA176Accident · 1 fatalField investigationFinal reportBoeing A-75 · Daytona Beach, FLThe biplane pilot failed to see and avoid the collision with the banner being towed by the other airplane.NTSB ATL89LA135Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Brooks, GAClimb not possible because of a downdraft which exceeded the performance capabilities of the airplane. Factors related to the accident were: inadequate location of the wind sock, the adverse wind conditions, and the trees.NTSB DEN88DTE02Accident · 1 fatalFinal reportBoeing A75N1 · Keenesburg, COThe commercial ag plt was starting a spray run on a new field. During the first pass, the aircraft struck power line wires. The aircraft rolled left and impacted the terrain in a wings level, nose low attitude. An immediate post crash fire destroyed the…NTSB MIA86LA240Accident · Minor injuriesLimited investigationFinal reportBoeing PT-17 · Dublin, MSWhile buzzing at a low altitude the aircraft struck a wire causing the pilot to loose control at which time the aircraft crashed to the ground.NTSB LAX84IA014Incident · No injuriesIncident investigationFinal reportCessna 152II · Woodland, CAThe Cessna 152 was performing a touch and go landng and had just taken off when the Boeing stearman landed on the left wing and propeller of the Cessna 152. Both acft landed sucessfully and taxied clear of the runway. Both acft were broadcasting their…NTSB CHI83LER03Accident · Serious injuriesFinal reportBoeing A75N1 · Sabin, MNAcft collided with power lines.NTSB LAX83LVD01Accident · Minor injuriesFinal reportBoeing A75 · Ft. Bragg, CAThe pilot reported that he was long and fast on his landing approach, so he decided to go around. Due to a noise sensitivity problem in the area, he elected not to use full throttle. Subsequently, the aircraft hit the tops of trees at the end of the runway.…