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_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 ('1151204')
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 ('1151204')
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 MIA87LA109Accident · No injuriesLimited investigationFinal reportBeech A23 · Palatka, FLThe pilot stated that he 'had to make downwind landing due to traffic & direction from UNICOM operator. Landing was fast due to downwind, but not hard. Nose wheel collapsed during rollout with stall warning blowing. Plane gently nosed over & stopped at the…NTSB ATL86FA082Accident · 2 fatalField investigationFinal reportBeech A23 · Russellville, ALOutboard half of one propeller blade separated during cruise flight. During the subsequent forced landing attempt the acft struck trees, severing the right wing, and crashed inverted. Front occupant seats separated from seat tracks. Examination of propeller…NTSB SEA85LA210Accident · Serious injuriesLimited investigationFinal reportBeech A23 · Winnemucca, NVThe student had recently purchased the acft. On 9/5/85, an instructor plt, who had delivered the acft to the Winnemucca arpt, gave the student a total of 0.4 hr dual instruction, which included 2 landings. The instructor then indorsed the student's log book…NTSB NYC84LA183Accident · No injuriesLimited investigationFinal reportBeech A23 · Matawan, NJLanding long at night to avoid unseen obstructions, the pilot misjudged his touchdown point and ran off the end of the rwy, colliding with brushy vegitation.NTSB NYC83LA239Accident · No injuriesLimited investigationFinal reportBeech A23 · Manchester, NHThe acft collided with VASI lights during an emergency landing. The pilot was making touch & go landings. On the 4th takeoff the engine lost power at 150 ft. the pilot switched the fuel selector to left tank and the engine regained power. In maneuvering at…NTSB ATL83FA194Accident · 2 fatalField investigationFinal reportBeech A23 · Dublin, VAThe acft collided with wires and crashed during a training mission. According to one of the cfi's other students the area in which the crash occurred was regularly used by the CFI for airwork. This airwork was normally performed at ABOUT800 ft AGL. On this…NTSB ATL83FKG01Accident · 1 fatalFinal reportBeech A23 · Junnel Hill, GADuring takeoff, the engine lost power at about 700 ft AGL. A forced landing was made in a pasture that was hilly with a gully running through it. During the landing, the aircraft first contacted the top of a small Hill in the pasture, then became airborne a…NTSB DEN82DA135Accident · No injuriesFinal reportBeech A23 · Oakes, NDDuring a night landing, the aircraft touched down about 220 ft short of the approach end of the runway. Reportedly, the wheels struck a "washout" and the plane was substantially damaged.NTSB CHI81FER53Accident · No injuriesClosedBeech A23 · Superior, WINTSB CHI81FEI24Accident · No injuriesClosedBeech A23 · Wooster, OHNTSB ATL81FKQ16Accident · Serious injuriesClosedBeech A23 · Lyman, MSNTSB ATL81FKG15Accident · No injuriesClosedBeech A23 · Cornelia, GANTSB MIA81DKT32Accident · Minor injuriesClosedBeech 23 · Naples, FLNTSB CHI81FER09Accident · No injuriesClosedBeech A23 · Stanton, MNNTSB SEA80DYE44Accident · No injuriesClosedBeech A23 · Morton, WANTSB CHI80FEI19Accident · No injuriesClosedBeech A-23 · New Phila, OHNTSB MKC80FTK06Accident · No injuriesClosedBeech A23 · Tea, SDNTSB NYC80FGM03Accident · Minor injuriesClosedBeech A23 · Bradford, PANTSB NYC78FFJ31Accident · No injuriesClosedBeech B23 · Reading Center, NYNTSB MIA78FA107Accident · 1 fatalClosedBeech A23 · Inverness, FLNTSB NYC78DHA29Accident · Minor injuriesClosedBeech A23 · New Hanover, PANTSB NYC78FGT09Accident · Minor injuriesClosedBeech A23 · State College, PANTSB NYC78DHA19Accident · No injuriesClosedBeech A23 · Sussex, NJNTSB MIA78FKJ08Accident · No injuriesClosedBeech A23 · Redhill, ALNTSB FTW77DQG40Accident · No injuriesClosedBeech B-23 · Dumas, TXNTSB MKC77DER21Accident · No injuriesClosedBeech A-23 · Goodland, MNNTSB NYC76FGM43Accident · No injuriesClosedBeech A-23 · Somerset, PANTSB MKC76DTK32Accident · No injuriesClosedBeech A23A · Prairie City, SDNTSB NYC76FFJ07Accident · Minor injuriesClosedBeech A23 · Allegany, NYNTSB CHI76FEV08Accident · No injuriesClosedBeech A23 · Maquon, ILNTSB CHI75FEV32Accident · Serious injuriesClosedBeech A23 · Shelbyville, ILNTSB NYC75DNJ29Accident · No injuriesClosedBeech A23 · White Plains, NYNTSB FTW75FRA15Accident · Serious injuriesClosedBeech A23 · College Statn, TXNTSB NYC75FHJ11Accident · No injuriesClosedBeech B23 · Flushing, NYNTSB CHI74FEI43Accident · No injuriesClosedBeech A23 · Tiffin, OHNTSB MKC74DER52Accident · No injuriesClosedBeech A23 · Sleepy Eye, MNNTSB DEN74FQA29Accident · No injuriesClosedBeech A23 · Santa Rosa, NMNTSB OAK74FVG23Accident · No injuriesClosedBeech A23A · Fair Oaks, CANTSB IAD74DLQ07Accident · No injuriesClosedBeech A23 · Owensboro, KYNTSB CHI73FEA38Accident · Serious injuriesClosedBeech 23 · Lanesville, INNTSB MKC73FER23Accident · Serious injuriesClosedBeech A23 · Eden Prairie, MNNTSB CHI73DET18Accident · No injuriesClosedBeech A23 · Griffith, INNTSB MIA73FKG52Accident · Minor injuriesClosedBeech A23 · Jefferson, GANTSB FTW73FPA18Accident · No injuriesClosedBeech A23 · Lancaster, TXNTSB FTW73FPD15Accident · No injuriesClosedBeech A23 · Roanoke, TXNTSB MIA72DKJ65Accident · No injuriesClosedBeech A23 · Catherine, ALNTSB NYC72DLJ33Accident · No injuriesClosedBeech A23 · Ocracoke, NCNTSB CHI72DEM72Accident · No injuriesClosedBeech A23 · Traverse Cty, MINTSB NYC72FHD38Accident · No injuriesClosedBeech B23 · Ambler, PANTSB OAK72FJY14Accident · 2 fatalClosedBeech 23 · Castillejos, RP
Back to Beech A23