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 ('1151252')
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 ('1151252')
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 ERA24LA070Accident · No injuriesClass 3 · LimitedFinal reportBeech A24 · Miami, FLA partial loss of engine power during initial climb for undetermined reasons, resulting in a forced landing.NTSB ERA23FA033Accident · 2 fatalClass 3 · FieldFinal reportBeech A24 · Keene, NHImproper maintenance of the fuel injector nozzles and the pilots’ failure to abort the takeoff during the takeoff roll. Contributing to the accident was the mechanic’s decision to return the airplane to service with the engine unable to attain its full rated…NTSB CEN20LA228Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 24 · Livingston, TXThe total loss of engine power due to the failure of the No. 3 cylinder for reasons that could not be determined based on available evidence.NTSB ERA18LA010Accident · Serious injuriesClass 3 · LimitedFinal reportBeech A24 · Manteo, NCThe failure of maintenance personnel to properly secure wiring during an electrical component installation, which resulted in arcing and smoke in the cockpit. Contributing to the outcome was the flight instructor's failure to attain a proper descent rate…NTSB WPR17LA202Accident · Minor injuriesLimited investigationFinal reportBeech A24R · Ogden, UTThe airplane's inability to maintain an initial takeoff climb for reasons that could not be determined based on available information.NTSB CEN12LA467Accident · Serious injuriesLimited investigationFinal reportBeech A24R · Miami, TXAn in-flight loss of control on final approach for undetermined reasons.NTSB CEN10LA432Accident · Serious injuriesLimited investigationFinal reportBeech A24R · Muskegon, MIA loss of engine power for undetermined reasons.NTSB MIA06FA098Accident · 2 fatalField investigationFinal reportBeech A24R · Okeechobee, FLThe pilot's failure to maintain aircraft control as a result of spatial disorientation and an in-flight break up. Contributing to the accident were the dark night and thunderstorms.NTSB FTW04LA071Accident · No injuriesLimited investigationFinal reportBeech BE-23 · Mena, ARThe loss of engine power for undetermined reasons and the pilot's misjudgment of altitude and distance during the forced landing which resulted in a collision with trees and transmission wires.NTSB SEA03FA123Accident · 3 fatalField investigationFinal reportBeech A24-R · Yellow Pine, IDThe pilot's failure to maintain clearance. Factors include trees and mountainous terrain.NTSB ATL03LA040Accident · Serious injuriesLimited investigationFinal reportBeech A24R · Titusville, FLThe loss of engine power for undetermined reasons. The pilot's failure to attain full power for takeoff in accordance with the operation handbook was a factor.NTSB ATL01LA013Accident · No injuriesLimited investigationFinal reportBeech BE-23-A24R · Jackson, MSDeer on the runway, which forced the pilot to make an evasive maneuver forcing him to the side of the runway and striking the marker lights.NTSB MIA99LA083Accident · No injuriesLimited investigationFinal reportBeech A24R · Philadelphia, MSThe failure of the pilot to ensure the aircraft tie down ropes were free from the aircraft prior to taxiing. This resulted in the aircraft turning uncontrolled when taxi was initiated due to a partially tied left wing, the pilot loosing control of the…NTSB IAD98LA084Accident · Minor injuriesLimited investigationFinal reportBeech BE24 · Beckley, WVThe pilot's mismanagement of the fuel supply in that the fuel selector was selected to the improper fuel tank, which resulted in fuel starvation and the loss of engine power.NTSB LAX96LA221Accident · No injuriesLimited investigationFinal reportBeech 23-A24R · Modesto, CAfuel exhaustion due to the pilot's inadequate preflight inspection of the aircraft.NTSB SEA95FA198Accident · 1 fatalField investigationFinal reportBeech A24R · Yakima, WAThe pilot's failure to maintain clearance from a tree. Factors related to the accident were: the pilot's poor judgment and ostentatious display to buzz.NTSB NYC94LA085Accident · No injuriesLimited investigationFinal reportBeech A-24-R · Hamburg, NYThe pilot's failure to establish a positive climb rate, which resulted in an inflight collision with trees. Factors were a tailwind, the pilot's premature raising of the flaps, and his failure to do a go around.NTSB SEA94LA112Accident · No injuriesLimited investigationFinal reportBeech A24R · Everett, WAFuel system pump contamination and procedures/directives were not followed.NTSB NYC90LA026Accident · No injuriesLimited investigationFinal reportBeech A24R · Bridgeport, CTThe airplane engine throttle cable failed and the engine power reduced to idle over long island sound, resulting in the ditching of the airplane.NTSB MIA89FA210Accident · 2 fatalField investigationFinal reportBeech A24R · Sarasota, FLFailure of the propeller hub due to previous damage, which resulted in subsequent fatigue failure of the hub; and failure of the pilot to maintain flying speed, which resulted in a stall and subsequent impact with the ground. Inadequate maintenance/inspection…NTSB DEN89LA147Accident · No injuriesLimited investigationFinal reportBeech A24R · Evanston, WYThe pilot became disoriented and delayed in taking remedial action, which resulted on a critically low fuel level. A factor related to the accident was: rough/uneven terrain in the emergency landing area.NTSB MIA89LA168Accident · No injuriesLimited investigationFinal reportBeech A24R · Gulfport, MSFailure of a #2 connecting rod assembly, which resulted in separation of the #2 cylinder and subsequent loss of engine power. Contributing factors were: inadequate maintenance, the transmission (power) line, and trees.NTSB SEA89LA085Accident · Serious injuriesLimited investigationFinal reportBeech A24R · Ely, NVThe pilot's improper decision to continue flight into IMC. Contributing to the accident were snow, obscuration and mountainous terrain.NTSB LAX89LA072Accident · No injuriesLimited investigationFinal reportBeech A24R · Grass Valley, CAAt the end of a cross country flight, during the landing roll, the airplane began to slide to the left. The pilot was unable to regain control due to the patchy snow and ice on the runway. The airplane exited the runway and collided with a snow bank. There…NTSB NYC89FA015Accident · 4 fatalField investigationFinal reportBeech A24R · Blue Bell, PAImproper VFR procedures, the pilot failed to maintian adequate airspeed for the attitude of flight of the airplane causing it to stall and collide with trees and a powerline during recovery.NTSB LAX89FA006Accident · 2 fatalField investigationFinal reportBeech A24R · Mt. Baldy, CAPilot's improper in-flight decision and altitude.NTSB DEN87LA113Accident · No injuriesLimited investigationFinal reportBeech A24R · Beulah, WYThe acft lost power during a normal climb on a personal trip. The private plt noticed a drop in fuel flow pressure and smelled fuel. The plt then selected boost pump on but the pressure stayed low. The plt elected to make a forced landing and selected a…NTSB SEA86LA238Accident · Minor injuriesLimited investigationFinal reportBeech A24R · Kent, WAA forced landing was made due to a loss of power for undetermined reasons. The power loss occurred at about 600 feet AGL. A slight left turn was made to land onto a road. The aircraft's left wing struck a tree separating it from the aircraft. The aircraft's…NTSB NYC86LA195Accident · No injuriesLimited investigationFinal reportBeech A24R · Tunkhannock, PADuring a landing in calm wind conditions, the acft bounced, became airborne again & touched down further down the 2000' rwy. The plt applied brakes & 'dumped' the flaps for max braking, but to no avail. The acft slid off the grass rwy & subsequently went over…NTSB NYC84FHM02Accident · Minor injuriesFinal reportBeech A24R · Spring Valley, NYThe acft went off the end of the rwy during an aborted takeoff after the engine backfired and ran rough. The plt closed the throttle as he discontinued the takeoff. Before the acft could be stopped it went off the rwys end and down an embankment. Post…NTSB CHI83LA349Accident · No injuriesLimited investigationFinal reportBeech A24R · Verona, WIThe acft lost power during cruise and was damaged in an off arpt forced landing. During the landing roll in a field, acft contacted a fence and collapsed the nose gear. Examination of the bendix fuel injector SN30479, model RSA-5AD1 revealed that the fuel…NTSB NYC83LA151Accident · Minor injuriesLimited investigationFinal reportBeech A24R · Montauk, NYThe acft landed short of the runway and collided with an embankment breaking the nose gear. The pilot stated the final approach was flown low and about 70 mph. At about 10-20 ft above the ground the acft started to sink and the pilotsaid he applied back…NTSB LAX83LA161Accident · Minor injuriesLimited investigationFinal reportBeech A24R · Upland, CAWhile on final apch to land, the plt saw 2 other acft taxi onto the rwy & began taking off. After the 2nd acft had pulled onto the rwy, the plt decided to go around. However as the acft on the rwy accelerated, there appeared to be sufficient room to land, so…NTSB CHI83FA014Accident · 1 fatalField investigationFinal reportBeech A24R · Lansing, MIWitnesses observed the acft flying in an easterly direction, level but in a slightly descending flight path. No smoke, flame or parts falling from the acft were observed. The eng sound was steady & loud. The descent continued at a shallow angle until impact.…NTSB LAX82FA183Accident · 4 fatalField investigationFinal reportBeech A24R · Near Mt. Shasta, CAThe flight originated at reno, NV, but the pilot landed at red bluff, CA after receiving an in-flight weather briefing. After landing, he obtained another weather briefing and was advised that VFR flight was not recommended. He then filed a VFR flight plan…NTSB LAX82FA156Accident · Minor injuriesField investigationFinal reportBeech A24R · Camarillo, CAThe pilot took off from the Camarillo airport on a local flight to practice touch and go landings. He had made two touch and go patterns and was on his third and final landing when the collision occurred. He had transmitted his position on downwind and base…NTSB ATL82FA026Accident · 2 fatalClosedBeech A24R · The Plains, VANTSB LAX82FA124Accident · 2 fatalClosedBeech A24R · Yucca Valley, CANTSB NYC78FGM35Accident · No injuriesClosedBeech A24R · W.Mifflin, PANTSB SEA78FYM36Accident · Minor injuriesClosedBeech A24R · Salem, ORNTSB MKC78FA033Accident · 2 fatalClosedBeech A24R · Mandan, NDNTSB NYC76FHA04Accident · No injuriesClosedBeech A24R · Collegeville, PANTSB NYC76FGT01Accident · Minor injuriesClosedBeech A24R · Hughesville, PANTSB CHI75AC069Accident · 3 fatalClosedBeech A24R · Beaver, WINTSB NYC75FNC17Accident · Serious injuriesClosedBeech A24R · Augusta, MENTSB MKC75FCQ21Accident · Serious injuriesClosedBeech A24R · Caney, KSNTSB IAD75AI010Accident · 2 fatalClosedBeech A24R · Wartburg, TNNTSB LAX75FUQ04Accident · No injuriesClosedBeech A24R · Lancaster, CANTSB OAK74AP064Accident · Serious injuriesClosedBeech A24R · Lincoln, CANTSB MIA74DLD51Accident · No injuriesClosedBeech A24R · Cocoa Beach, FL
Back to Beech A24R