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 ('1151520')
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 ('1151520')
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 MKC86LA051Accident · No injuriesLimited investigationFinal reportBeech V35 · Bassett, NEWhile landing his acft at Bassett, Nebraska the plt rptd a gust of wind hit the acft fm behind and he lost directional control veering off into a snow bank. The plt stated that two witnesses who were walking near the rwy told him no wind was blowing when the…NTSB FTW85MA297Accident · 3 fatalMajor investigationFinal reportBeech H35 · El Reno, OKThe acft took off at 1054 CDT in VMC with no flt plan. At that time, there was a rprtd ceiling of 1800 ft. at 1112 CDT, the plt rprtd he was at 10,000 ft, 'just reaching the tops.' At 1137 CDT, he stated 'we're about 60 west of oke city, westbound to sayre…NTSB FTW85FPA02Accident · Serious injuriesFinal reportBeech H35 · Wichita Falls, TXThe acft made a shallow rt turn and descended to ground contact during a go-around after the plt was informed by radio that his landing gear was not fully extended. Investigation revelaed also that the main fuel tanks were empty and the tank selector was on…NTSB CHI85LA178Accident · Minor injuriesLimited investigationFinal reportBeech H35 · Lima, OHThe plt was flying the acft back to the home arpt following an annual inspection when he noticed the oil pressure was falling to zero. Aprx 3 min later, the eng seized. Subsequently, an emerg gear-up landing was made in a farm field. An exam revealed the oil…NTSB FTW84FA103Accident · 1 fatalField investigationFinal reportBeech H35 · Taos, NMThe plt stated that a new fuel system had just recently been installed in miami, FL & he forgot about the new system while switching tanks & accidently turned it to the off position. When the eng quit he realized what he had done & switched back to a full…NTSB LAX84LA112Accident · 1 fatalLimited investigationFinal reportBeech H35 · Modesto, CAThe plt taxied & initiated a takeoff without obtaining a clearance. The tower controller observed the acft take off, immediately turn left, then collide with a 10 ft dirt bank, located between the parallel rwys. After hitting the dirt bank, the acft skidded…NTSB DEN83LA226Accident · No injuriesLimited investigationFinal reportBeech H35 · Salida, COThe acft touched down about 1/2 way down the rwy, left of centerline. The acft then struck a small ridge of dirt & rocks& came to rest with the left landing gear collapsed.NTSB CHI83IA300Incident · No injuriesIncident investigationFinal reportBeech H-35 · Graceville, MNOn landing roll on slick grass with a crosswind the acft slid to the right and the right wing tip struck a tree.NTSB LAX83FA256Accident · 4 fatalField investigationFinal reportBeech H35 · Antioch, CAThe acft collided with the ground in a nose low attitude during flt in the traffic pattern to land. Witnesses described the pattern as being close in, slow and low compared to normal traffic. The attitude of the acft was described as nose high. As the acft…NTSB LAX83FA098Accident · No injuriesField investigationFinal reportBeech H35 · Tucson, AZDuring arrival, the plt was advised of the position of a Boeing 727 that was landing on rwy 29R & he reported seeing theacft. He also was cautioned about possible wake turbulence from the Boeing & he acknowledged. The plt reported that while he was on an…NTSB FTW83LA022Accident · No injuriesLimited investigationFinal reportBeech H35 · Abilene, TXThe pilot stated that he extended the gear about 10 to 15 miles out to hold down the speed and descend. Before landing, he noted that none of his lights were working and he was unable to communicate with Abilene radio. Reportedly, he assumed the gear was down…NTSB MIA83LA009Accident · 2 fatalLimited investigationFinal reportBeech H35 · Missing Acft (Atlantic Ocean)Aircraft Missing on a flight from marsh harbour Bahamas to ft. pierce FL. Thunderstorms were along the proposed route. Last recorded position on radar data log was at 27-06-13 north and 79-27-58 west. No radio communications were reported with flight after…NTSB NYC81FHM11Accident · Serious injuriesClosedBeech H35 · Wappingers Fls, NYNTSB LAX81FUJ63Accident · Minor injuriesClosedBeech H35 · Winslow, AZNTSB MKC81FCG12Accident · No injuriesClosedBeech H35 · Columbia, MONTSB MIA80OLD99Accident · No injuriesClosedBeech H35 · Gulf Of Mexico (Gulf of Mexico)NTSB DEN80FA020Accident · 3 fatalClosedBeech H35 · Copperton, UTNTSB LAX80FVM08Accident · No injuriesClosedBeech H35 · San Jose, CANTSB MKC79FCJ23Accident · Serious injuriesClosedBeech H35 · Wilcox, NENTSB OAK79FVM20Accident · Minor injuriesClosedBeech H35 · Palo Alto, CANTSB LAX79DVA25Accident · No injuriesClosedBeech H35 · Porterville, CANTSB OAK78FVD04Accident · Serious injuriesClosedBeech H35 · Novato, CANTSB NYC77FHA31Accident · 1 fatalClosedBeech 35H · Avoca, PANTSB MKC77FA026Accident · 2 fatalClosedBeech H35 · Beawfort, MONTSB MIA77FKJ42Accident · No injuriesClosedBeech H35 · Bessemer, ALNTSB DEN77FA040Accident · 4 fatalClosedBeech J35 · Lander, WYNTSB LAX77FUA09Accident · No injuriesClosedBeech H35 · Fullerton, CANTSB LAX77FA032Accident · 1 fatalClosedBeech H35 · Wrightwood, CANTSB MIA77FA038Accident · 6 fatalClosedBeech H35 · Claxton, GANTSB OAK77FA007Accident · 4 fatalClosedBeech H-35 · Vacaville, CANTSB FTW76DQH04Accident · No injuriesClosedBeech H35 · Midland, TXNTSB SEA76AS063Accident · 4 fatalClosedBeech H35 · Mccall, IDNTSB NYC76FHM27Accident · Serious injuriesClosedBeech H35 · La Grange, NYNTSB OAK76DVW20Accident · No injuriesClosedBeech H35 · Carp, NVNTSB MKC76DCD32Accident · No injuriesClosedBeech H35 · Des Moines, IANTSB LAX76FUQ12Accident · No injuriesClosedBeech H35 · Burbank, CANTSB DEN76AD019Accident · 4 fatalClosedBeech H35 · Aspen, CONTSB MIA76DLA13Accident · No injuriesClosedBeech H35 · Gainesville, FLNTSB MKC76FER23Accident · No injuriesClosedBeech H35 · Blaine, MNNTSB MIA76FLD11Accident · No injuriesClosedBeech H35 · Lutz, FLNTSB NYC75FGM43Accident · No injuriesClosedBeech H35 · West Mifflin, PANTSB OAK75FVM23Accident · Minor injuriesClosedBeech H35 · San Jose, CANTSB FTW75FPG31Accident · No injuriesClosedBeech H35 · England, ARNTSB DEN75AD031Accident · 1 fatalClosedBeech H35 · Provo, UTNTSB OAK75AP021Accident · 3 fatalClosedBeech H35 · Hayward, CANTSB FTW75FPG25Accident · No injuriesClosedBeech H35 · Alexander, ARNTSB FTW75FPD04Accident · No injuriesClosedBeech H35 · Rhome, TXNTSB DEN75DTE11Accident · Minor injuriesClosedBeech H35 · Hugo, CONTSB FTW74FQG35Accident · No injuriesClosedBeech H35 · Canyon, TXNTSB OAK74AP021Accident · 2 fatalClosedBeech H35 · Georgetown, CA
Back to Beech H35