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 ('1151508')
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 ('1151508')
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 SEA89FA157Accident · 1 fatalField investigationFinal reportBeech C35 · Sandy, ORThe loss of engine power due to the separation of the bolt connecting the throttle rod to the carburetor throttle arm and an inadequate annual inspection performed 5 flight hours prior to the occurrence. Contributing factors were obstructions in and around…NTSB DEN89FA146Accident · 1 fatalField investigationFinal reportBeech 35 · Glenrock, WYProper altitude not maintained by the pilot. The weather/night conditions and pilot fatigue were considered to be contributing factors.NTSB DEN88LA140Accident · No injuriesLimited investigationFinal reportBeech C35 · Brighton, COShortly after takeoff and while cruise flight, the eng lost pwr. The fuel pressure gauge indicated o PSI. The plt switched on the electric fuel pump. The eng did not respond. The plt activated the auxiliary (wobble) pump and switched fuel tanks. The eng still…NTSB MKC88LA105Accident · No injuriesLimited investigationFinal reportBeech 35C · Manhattan, KSArriving at the original destination apt, the PIC decided on an alternate, nearby airport, due to confusion regarding runway conditions at the original destination apt. Flying to his alternate, he erroneously lined up at a military airport located about 10…NTSB DEN88LA012Accident · Minor injuriesLimited investigationFinal reportBeech C35 · Ekalaka, MTDuring the takeoff roll the pilot encountered an unexpected tailwind. The pilot reported that he tried to abort the takeoff but tall grass and the tailwind did not allow the aircraft to decelerate properly. The aircraft ran through two drainage ditches and…NTSB MKC87LA123Accident · No injuriesLimited investigationFinal reportBeech C35 · Spencer, IADuring ldg, PIC failed to maintain directional control and swerved off the rwy. Ldg gear collapsed and acft was substantially damaged. Witnesses said plt and pax were behaving irrationally prior to lvf departure apt. PIC left the scene of accident and two…NTSB LAX87LA175Accident · No injuriesLimited investigationFinal reportBeech C35 · Vacaville, CAThe plt stated he had flown the acft the day prior to the accident on the left fuel tank only. No fuel had been added on the day of the accident and the plt stated that the left tank was three quarters full and the right tank was full. The plt positioned the…NTSB CHI87LA088Accident · No injuriesLimited investigationFinal reportBeech C-35 · Lake Station, INThe aircraft struck a guard rail during an emergency landing on interstate 80 after experiencing fuel exhaustion. The pilot had visually inspected his fuel supply prior to the first leg of the flight and thought there was enough fuel for the trip. Inspection…NTSB ATL86LA233Accident · No injuriesLimited investigationFinal reportBeech C35 · Akron, OHThe plt stated that one to two minutes after the fuel selector was changed from the right to left tank, the eng quit. The aux pump was turned on and fuel selector changed back to the right tank. Then to aux tank then back to left tank. The engine would not…NTSB MIA86LA245Accident · No injuriesLimited investigationFinal reportBeech G-35 · Lantana, FLShortly after takeoff the cabin door opened. The pilot continued the short flight to his home airfield. During approach he stated that due to the increased noise in the cabin he forgot to lower the landing gear. The aircraft contacted the runway with the…NTSB NYC85LA252Accident · No injuriesLimited investigationFinal reportBeech C35 · Wexford, PAAircraft was landing on private grass strip and during landing roll struck a deer with the right wing tip. The grass was wet and the pilot lost directional control. The aircraft impacted trees that bordered the airstrip and was destroyed.NTSB MIA85FA159Accident · 4 fatalField investigationFinal reportBeech C35 · Tampa, FLWitnesses observed the acft takeoff on rwy 36 in foggy conditions. They reported that during the initial climb after lift-off, the acft pitched up & rolled into a steep left bank, then entered a descent & crashed on an aprx heading of 060 deg. Impact occurred…NTSB MKC84FA174Accident · 4 fatalField investigationFinal reportBeech C35 · Broken Bow, NEWhile on an IFR flt at 6000 ft, the plt requested, and was granted a deviation around wx. Later, N335W informed denver ARTCC that they were going to get into some moderate turbulence for a little bit but that it looked like the light at the end of the tunnel.…NTSB FTW84LA250Accident · Minor injuriesLimited investigationFinal reportBeech C35 · Arnett, OKAccording to the plt, the wx for his route of flt was forcast to remain VFR. En route, ceilings at 4000 to 5000 ft MSL were encountered in the vicinity of hobart, OK. As the flt continued the wx deteriorated. In order to maintain VFR conditions, the…NTSB NYC84LA028Accident · No injuriesLimited investigationFinal reportBeech C35 · Martha'S Vineyard, MAThe plt had departed Martha'S Vineyard arpt & was climbing over lagoon pond (a large body of salt water) at aprx 900 ft AGL when the eng lost power. The plt decided the arpt was too FAR away for an emergency landing & there were trees in the area, so he…NTSB MKC83FA214Accident · Serious injuriesField investigationFinal reportBeech C35 · Grain Valley, MOThe plt reported that when he was on final apch to land, the eng quit running & he was unable to glide to the rwy. Reportedly, the acft touched down in a vacant lot about 75 ft short & 15 ft below the level of the end of the rwy. After touching down, it…NTSB DEN83LA174Accident · Minor injuriesLimited investigationFinal reportBeech C35 · Salida, COThe acft crashed into a mountain in a controlled crash situation with full flaps and full power at the 11,312 ft level the density alt was computed to be 12,370 ft MSL. The plt was aware that the weather was questionable in some areas of his route and the…NTSB CHI82DA254Accident · No injuriesFinal reportBeech C35 · Hamilton, OHDuring arrival, the pilot observed a thunderstorm just southof the airport with visible lighting. As the pilot continued his approach to runway 29, he noticed that the wind gusts had picked up. During the flare, a gust lifted his left wing and the right wing…NTSB FTW82DA222Accident · Minor injuriesFinal reportBeech C-35 · Ryan, OKOn arrival at the destination airport the pilot determined the grass strip was too wet for a landing. The pilot selecteda farm road and stated that a gust of wind struck the aircraft at about 10 to 12 feet above the road. The aircraft landed hard and swerved…NTSB CHI82DA148Accident · No injuriesFinal reportBeech C35 · Dillsboro, INThe aircraft operated normally during taxi, run-up, takeoff, and climb to 3500 ft MSL. About 17 miles from the departureairport, the engine stopped running. During a forced landing in a dirt field, one of the main gear failed. The propellerseparated and the…NTSB LAX81FVG55Accident · No injuriesClosedBeech C35 · Napa, CANTSB DEN81FA045Accident · 2 fatalClosedBeech C35 · Spanish Forks, UTNTSB MIA81DA035Accident · 4 fatalClosedBeech C35 · Missing AircraftNTSB FTW81DQD10Accident · No injuriesClosedBeech C35 · Carlsbad, NMNTSB DEN80FTK17Accident · No injuriesClosedBeech C35 · Yankton, SDNTSB NYC80FA053Accident · 1 fatalClosedBeech C35 · Spring Valley, NYNTSB MKC80FTG02Accident · Serious injuriesClosedBeech C35 · Grand Forks, NDNTSB MKC80FCD07Accident · No injuriesClosedBeech C35 · Somers, IANTSB FTW79FA111Accident · 3 fatalClosedBeech C35 · Ranger, TXNTSB CHI79DEE77Accident · No injuriesClosedBeech C35 · Chicago, ILNTSB MIA79FLD29Accident · No injuriesClosedBeech C35 · Brooksville, FLNTSB MKC79DER02Accident · No injuriesClosedBeech C35 · Pipestone, MNNTSB MKC78FCJ45Accident · Minor injuriesClosedBeech C35 · Gordon, NENTSB LAX78DUK01Accident · No injuriesClosedBeech C35 · Cottonwood, AZNTSB SEA78FA058Accident · 2 fatalClosedBeech C35 · Redmond, ORNTSB DEN77DQA48Accident · No injuriesClosedBeech C35 · Albuquerque, NMNTSB FTW77FA066Accident · Minor injuriesClosedBeech C35 · Fort Worth, TXNTSB OAK77FVG58Accident · Minor injuriesClosedBeech C35 · Placerville, CANTSB MKC77FA031Accident · 3 fatalClosedBeech C35 C35 · Omaha, NENTSB DEN77DQA34Accident · No injuriesClosedBeech C35 · Reserve, NMNTSB OAK77FVW11Accident · Minor injuriesClosedBeech C35 · Las Vegas, NVNTSB SEA77FA012Accident · 3 fatalClosedBeech C35 · Mckenna, WANTSB MIA78DKT04Accident · Minor injuriesClosedBeech C35 · Key Largo, FLNTSB SEA77FYG05Accident · No injuriesClosedBeech C35 · Colville, WANTSB NYC76FHM32Accident · Serious injuriesClosedBeech C35 · Marlboro, NJNTSB IAD76FIG21Accident · No injuriesClosedBeech C35 · Annapolis, MDNTSB IAD76DLQ22Accident · No injuriesClosedBeech C35 · Bronston, KYNTSB MKC76FCQ44Accident · No injuriesClosedBeech C35 · Mankato, KSNTSB FTW76FQD19Accident · No injuriesClosedBeech C35 · El Paso, TXNTSB CHI76FEV17Accident · No injuriesClosedBeech C35 · Pontiac, IL
Back to Beech C35