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 ('1151254')
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 ('1151254')
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 LAX89LA249Accident · No injuriesLimited investigationFinal reportBeech C24R · Lower Lake, CAPilot-in-command's failure to identify the sink rate soon enough to take corrective action.NTSB LAX89LA142Accident · No injuriesLimited investigationFinal reportBeech C24R · Tucson, AZPilot misjudged the landing. The pilot began his flare too high above the runway resulting in a hard landing.NTSB BFO87LA036Accident · No injuriesLimited investigationFinal reportBeech C-24R · Chestertown, MDThe pilot, unfamiliar with the airport, intended to perform a trial takeoff run to determine how the aircraft accelerated on the grass runway. During the trial run when the aircraft was about half way down the runway, the pilot felt the aircraft was ready to…NTSB CHI87LA095Accident · No injuriesLimited investigationFinal reportBeech C24R · Manitowoc, WIPilot flared too high on landing. Aircraft landed hard and nose wheel broke off.NTSB MIA87LA101Accident · No injuriesLimited investigationFinal reportBeech C24R · Milton, FLThe acft crashed in a river aprx 1 mile west of his alternate landing location after the eng quit while descending for an apch, due to fuel exhaustion.NTSB NYC86LA208Accident · Serious injuriesLimited investigationFinal reportBeech C24R · Hartford, CTThe Beech 24R pilot noticed a build-up of a substance on the windshield. He also experienced a problem controlling the propeller. He said upon landing he could not judge forward visibility and flared high (30-40 ft). The pilot reported that the aircraft…NTSB LAX86FA278Accident · 4 fatalField investigationFinal reportBeech C24R · Meyers, CAWith a density altitude of about 8400 ft, and an aircraft near its max certificated gross weight, the plt & 3 pax departed on rwy 18. During takeoff either the pilot's door was not closed or it came open. The open door degraded the acft's climb performance.…NTSB LAX85IA225Incident · No injuriesIncident investigationFinal reportBeech C24R · Fresno, CAWhile ldg with a left quartering tailwind the student plt bounced the acft. He failed to go around as he had been instructed to do, & after the acft bounced 2 more times its nose gear collapsed. Damage to the acft was minor.NTSB LAX85FA111Accident · No injuriesField investigationFinal reportBeech C24R · Riverside, CAAn aborted takeoff was attempted by the plt when the acft failed to sustain flight. He landed on the side of the runway with one wheel in the grass and realized too late that normal braking was not sufficient to stop the landing roll before the acft went over…NTSB LAX85LA057Accident · Serious injuriesLimited investigationFinal reportBeech C24R · Rialto, CAAt about 0730 PST, witnesses near the lytle creek ranger station, located northwest of Rialto, CA, heard an acft circling low in the area, then heard the sound of impact nearby. The wx at the time was described as overcast with zero visibility in fog & light…NTSB LAX85IA052Incident · No injuriesIncident investigationFinal reportBeech C24R · Glendale, CAAfter a loss of eng power, the plt made a forced landing on a street. While landing, the tip of the vertical stabilizer snagged a guy wire which crossed the street. The aircraft owner stated that the electrical fuel pump needed a rotor & body kit. He…NTSB DEN84LA304Accident · No injuriesLimited investigationFinal reportBeech C24R · Bismarck, NDPlt calculated the flt to be 4 hours 33 minutes long and there were 5.2 hrs of fuel on board. Plt stated, en route he was requested to climb from 6,000 ft to 8,000 ft then to 9,000 which was performed at 'full power, fuel full burn.' Stronger headwinds were…NTSB NYC84LA246Accident · No injuriesLimited investigationFinal reportBeech C24R · Newmarket, NHPlt reported loss of power in flight and executed a forced landing in a wooded area. Reason for the power loss was not determined.NTSB ATL84LA146Accident · No injuriesLimited investigationFinal reportBeech C-24R · Bedford, VAThe straight-in approach was high over the trees on the approach end of the rwy. The plt waited until he was 1/2 way down the 3000 ft rwy to reduce eng power to idle. The acft floated before dropping to the rwy & bouncing back into the air. Power was applied…NTSB LAX84LA146Accident · No injuriesLimited investigationFinal reportBeech C-24-R · Fullerton, CAA rear seated passg reported that when the acft was about 50 ft AGL he heard the stall warning buzzer sound. Several seconds later acft hit the rwy in a near level attitude. The landing was described by the passgs as 'on the hard side.' Investigation revealed…NTSB LAX84LA093Accident · No injuriesLimited investigationFinal reportBeech C24R · Monterey, CAFire erupted in the eng compartment during the eng run-up. Investigaiton revealed that 7 of the 8 nuts securing the exhaust manifold to the cylinders were missing. The only nut present was loose but retained the #1 cyl exhaust tube. The #2 cyl exhaust tube,…NTSB FTW84LA025Accident · No injuriesLimited investigationFinal reportBeech C24R · Prairie Grove, ARThe plt stated that about 15 min after takeoff, the radio & navigation equpment quit working. He decided to return to the arpt to land. However, when he tried to extend the gear, he could not get a safe gear down indication. There was heavy traffic, so he…NTSB CHI83LA276Accident · Serious injuriesLimited investigationFinal reportBeech C24R · Saint Cloud, MNShortly after takeoff, the plt's door came open. He tried to close it, but was unable, so he turned back toward the arpt to land. While making a turn before landing, the eng lost power. Shortly after that, the acft started falling to the right & crashed. An…NTSB ATL83LA143Accident · Minor injuriesLimited investigationFinal reportBeech C24R · Waycross, GADuring flt, the plt encountered strong headwinds & decided to divert to Waycross, GA. While using fuel from the right tank, the engine quit due to fuel starvation. The plt stated that this surprised him since the right fuel gauge needle was only slightly…NTSB MKC83LA002Accident · No injuriesLimited investigationFinal reportBeech C24R · Centerville, IAThe pilot reported that the approach was a little high and fast, then the right tire blew out on touchdown. He stated that power was added to maintain directional control, and he was unable to stop at the end of the runway. However, witnesses indicated that…NTSB DEN82DA172Accident · No injuriesFinal reportBeech C24R · Palisade, COAccording to the pilot, the flight departed the arapahoe airport with the fuel tanks half full because of passenger load factor. As the aircraft approached within 45 miles of the destination airport, the pilot switched from the right fuel tank to the left…NTSB NYC82FA199Accident · 3 fatalField investigationFinal reportBeech C24R · Trenton, NJDuring an approach to the mercer county airport at Trenton, n.j., the aircraft lost power and landed off airport in trees. The fuel selector was found positioned between left tank and off. The pilot attempted to fly to the runway, but unable. The aircraft…NTSB LAX82DA204Accident · No injuriesFinal reportBeech C-24R · Big Bear, CAA witness observed the aircraft to pitch and roll while on final approach. At about 30-40 feet above the ground the nose pitched downward and the aircraft collided with the runway. Moderate turbulence and gusty winds were reported on final approach.NTSB NYC82DA043Accident · No injuriesFinal reportBeech C-24R · Manchester, NHThe tower controller advised the flight while on base leg that the winds were from 300 degrees at 15 knots. This information was given at 1045 EST and was the last wind information given to the pilot before landing. According to the pilot moderate turbulence…NTSB FTW81FPG63Accident · No injuriesClosedBeech C24R · Searcy, ARNTSB SEA81FA054Accident · 3 fatalClosedBeech C24R · Snoqualmie Ps, WANTSB FTW81FA138Accident · 2 fatalClosedBeech C24R · Shreveport, LANTSB DEN81FTE64Accident · Minor injuriesClosedBeech C24R · Broomfield, CONTSB MIA81DKJ13Accident · No injuriesClosedBeech C-24R · Crestview, FLNTSB ATL81FLG15Accident · Minor injuriesClosedBeech C24R · Bennettsville, SCNTSB DEN81FA043Accident · 3 fatalClosedBeech C24R · Leadville, CONTSB FTW81FQA22Accident · Serious injuriesClosedBeech C24R · Albuquerque, NMNTSB CHI81FEE10Accident · Minor injuriesClosedBeech C24R · West Chicago, ILNTSB ATL80DKJ32Accident · No injuriesClosedBeech C24R · Decatur, ALNTSB MIA80FA111Accident · 2 fatalClosedBeech C24R · Lake Wales, FLNTSB SEA80DYA23Accident · No injuriesClosedBeech C24R · Soda Springs, IDNTSB MKC80DER32Accident · No injuriesClosedBeech C24R · Blaine, MNNTSB IAD79FA056Accident · 3 fatalClosedBeech C24R · Woodbridge, VANTSB OAK79FVD08Accident · Serious injuriesClosedBeech C-24R · San Leandro, CANTSB MKC79FTG02Accident · Serious injuriesClosedBeech C24R · Grand Forks, NDNTSB CHI79FEE02Accident · Minor injuriesClosedBeechcraft C24R · Sugar Grove, ILNTSB MKC78FCG71Accident · No injuriesClosedBeech C24R · Joplin, MONTSB OAK78FA049Accident · 4 fatalClosedBeech C-24R · Big Sur, CANTSB ANC78FA054Accident · 4 fatalClosedBeech C24R · Kenai, AKNTSB MKC78FER06Accident · No injuriesClosedBeech C-24R · Camp Ripley, MNNTSB UNK78X0102Accident · No injuriesClosedBeech C24R · Freemason Isl, LANTSB NYC77FFA01Accident · Minor injuriesClosedBeech C24R · Meredith, NYNTSB MIA77FA050Accident · 2 fatalClosedBeech C24R · Monroe, GA
Back to Beech C24R