Skip to content

NTSB investigations · 21

Matched to the registry by N-number and event date, newest first.

Query with SQL

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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey WHERE a.aircraft_model_code IN ('1380136') ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
  WHERE a.aircraft_model_code IN ('1380136')
  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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('1380136')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 CEN22LA003Accident · Minor injuriesClass 4 · LimitedFinal reportBoeing PT-17 · Winnie, TXThe pilot’s decision to takeoff from a road with obstacles in his flight path and his failure to maintain control of the airplane when encountering changing winds from approaching thunderstorms which resulted in the airplane impacting signal light cables.Oct 2, 2021 · N4106Y · Substantial damage NTSB GAA15CA082Accident · Minor injuriesData collectionFinal reportBoeing PT 17 · Williamson, GAThe pilot landed off the right side of the runway resulting in a collision with terrain.May 20, 2015 · N55528 · Substantial damage NTSB ATL03LA118Accident · Minor injuriesLimited investigationFinal reportBoeing PT-17 · Hendersonville, NCThe pilot's inadequate preflight planning/preparation of fuel required for the flight, resulting in a total loss of engine power due to fuel exhaustion. A factor in the accident was pilot impairment due to alcohol consumption.Jul 19, 2003 · N411BT · Substantial damage NTSB ATL83FA171Accident · No injuriesField investigationFinal reportBoeing A75N1 · Kennesaw, GAWhile over a wooded area at 800 ft AGL the eng failed. The plt was unable to reach a suitable landing site before contacting the ground on an embankment below the elevation of a nearby road. The acft struck a telephone cable prior to touchdown. The #4 conrod…Apr 27, 1983 · N74189 · Substantial damage NTSB ATL82DA123Accident · No injuriesFinal reportBoeing A75N1 · Marietta, GAThe Boeing A75N1 (stearman) pilot reported that a long final approach was flown to allow room for a twin engine aircraft to land in front of him. He continued landing, but did not see a beige colored Cessna 172 on the runway. He reported that the visibility…May 1, 1982 · N74189 · 2 aircraft · Minor damage NTSB FTW79FRJ52Accident · No injuriesClosedBoeing PT-17 · Shreveport, LASep 13, 1979 · N63804 · Substantial damage NTSB IAD77FID29Accident · Minor injuriesClosedBoeing A75N1 · Fredericksburg, VASep 10, 1977 · N17PT · Substantial damage NTSB LAX77FUA18Accident · 2 fatalClosedBoeing PT-17 · Costa Mesa, CAJul 6, 1977 · N977Y · Destroyed NTSB SEA76DYI20Accident · No injuriesClosedStearman PT-17 · Frenchelenn, ORJul 11, 1976 · N9182Z · Substantial damage NTSB SEA76DTI19Accident · No injuriesClosedStearman PT-17 · Marias Pass, MTJan 23, 1976 · N60131 · Substantial damage NTSB FTW74FPG46Accident · No injuriesClosedStearman PT-17 · Little Rock, ARJan 31, 1974 · N6904 · Substantial damage NTSB SEA73DYG35Accident · No injuriesClosedBoeing PT-17 · Odessa, WAMay 15, 1973 · N67237 · Substantial damage NTSB OAK72DVG01Accident · No injuriesClosedBoeing A75N1 · Meridian, CAJul 2, 1971 · N9697H · Substantial damage NTSB LAX70D0103Accident · Serious injuriesClosedBoeing A75N1 · Somerton, AZAug 7, 1969 · N62850 · Substantial damage NTSB LAX69D0244Accident · Serious injuriesClosedBoeing N75N1 · Yuma, AZDec 11, 1968 · N56762 · Destroyed NTSB OAK68D0101Accident · No injuriesClosedBoeing A75 · Fresno, CAAug 23, 1967 · N63457 · Substantial damage NTSB SEA67D0139Accident · No injuriesClosedStearman PT-17 · Big Horn, MTAug 12, 1966 · N51132 · Substantial damage NTSB OAK65F0033Accident · Minor injuriesClosedBoeing A75N1 · Yuba City, CAApr 17, 1965 · N9697H · Destroyed NTSB DEN65D0053Accident · No injuriesClosedStearman A75N1 · Yuma, AZMar 8, 1965 · N56762 · Substantial damage NTSB UNK64X4122Accident · No injuriesClosedBoeing A75N1 · Kingsburg, CASep 24, 1964 · N49957 · Substantial damage NTSB UNK64X2065Accident · No injuriesClosedBoeing PT17 · Silvers, ORJun 2, 1964 · N9182Z · Substantial damage

Back to Boeing PT-17