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 ('1152006')
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 ('1152006')
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 GAA25WA273Accident · No injuriesClass 5 · ForeignBeech A45 · Guatemala City, GuatemalaNTSB WPR24FA184Accident · 1 fatalClass 3 · FieldFinal reportBeech A45 · Deer Harbor, WAThe pilot’s decision to perform an aerobatic maneuver at low level, and his misjudged entry altitude for the maneuver, which resulted in impact with water.NTSB GAA24WA058AccidentClass 5 · ForeignBeech A45 · Guatemala City, GuatemalaNTSB ERA17FA107Accident · 1 fatalField investigationFinal reportBeech A45 · Climax, GAThe failure of maintenance personnel to ensure that the throttle and fuel metering unit AN "B" nut was secured, which resulted in a total loss of engine power in flight and a subsequent collision with trees while attempting to land after sunset.NTSB WPR14LA117Accident · Serious injuriesLimited investigationFinal reportBeech A45 · Hollister, CAThe total loss of engine power during initial climb due to fuel starvation and the pilot’s inadequate preflight inspection and improper fuel management.NTSB WPR13FA284Accident · 2 fatalField investigationFinal reportBeech A45 · Boulder City, NVThe pilot/mechanic's loss of control during an emergency descent following a loss of engine power while in cruise flight. Contributing to the accident was the pilot/mechanic's incorrect assembly of the No. 6 cylinder at the last cylinder change, which…NTSB DEN08LA057Accident · No injuriesLimited investigationFinal reportBeech A45 · Englewood, COThe pilot's improper decision to fly the airplane with a discharged battery, which resulted in a total electrical failure during takeoff climb. Contributing factors were the pilot's inability to verify the landing gear position, and the impact with the runway…NTSB DEN05FA032Accident · 2 fatalField investigationFinal reportBeech A45 · Montgomery, TXthe in-flight separation of the left wing as a result of extensive fatigue cracking throughout the wing carry-through structure.NTSB ATL04LA157Accident · Minor injuriesLimited investigationFinal reportBeech A45 · LaGrange, GAThe maintenance personnel under-torquing of the crankcase throughbolts during top overhaul, which resulted in crankcase fretting, and the subsequent fatigue failure of the crankshaft at the No. 4 main journal. A factor was the lack of suitable terrain for…NTSB FTW04FA025Accident · 2 fatalField investigationFinal reportBeech A45 · Montgomery, TXThe non-compliance with applicable Airworthiness Directives which required wing spar inspections, and the continued operation of the aircraft beyond the compliance time extension granted as per the approved alternate means of compliance (AMOC). Also causal…NTSB MIA03LA069Accident · No injuriesLimited investigationFinal reportBeech A45 · Merritt Island, FLThe separation of both propeller blades in-flight for undetermined reasons and the failure of the pilot to attain the proper touchdown during the forced landing resulting in overrun during landing and subsequent collapse of the nose landing gear. A…NTSB MIA01LA233Accident · No injuriesLimited investigationFinal reportBeech A45 · Eatonton, GAThe inadvertent sliding of the airplane on tall grass when the pilot aborted takeoff and the swerved the airplane to the left of the runway to avoid deer which had walked onto the runway, resulting in the airplanes left wing contacting a tree.NTSB MIA01FA119Accident · 1 fatalField investigationFinal reportBeech A-45/T-34A · Claxton, GAThe pilot in command's failure to maintain airspeed while performing an emergency landing after having just taken off with an unsecured fuel cap, which resulted in an inadvertent stall mush, an uncontrolled descent, and an impact with trees.NTSB ATL99FA072Accident · 2 fatalField investigationFinal reportBeech T-34A · Rydal, GAFracture of the wing spar as a result of fatigue cracking that occurred over an unknown number of flights and flight hours with a wing loading spectrum not anticipated during design of the airplane. This report was modified on November 2, 2005.NTSB CHI90LA152Accident · No injuriesLimited investigationFinal reportBeech T-34A · Champaign, ILThe pilot's inadequate compensation for wind conditions, and his failure to adequately flare the aircraft for landing. The adverse wind was a related factor.NTSB ATL89FA175Accident · 2 fatalField investigationFinal reportBeech A45 · Troy, ALThe pilot's improper use of the airplane flight controls during a aerobatic maneuver at low altitude due to his lack of aerobatic experience. A contributing factor was the pilot's overconfidence in his ability to perform the maneuver.NTSB LAX87LA325Accident · 1 fatalLimited investigationFinal reportBeech A45 · Mammoth Lakes, CADuring an airshow performance, the acft collided with the terrain in a near vertical attitude. The maneuver the plt was to perform was a cuban eight. The first half of the maneuver was flown correctly, however, during the second half of it the acft remained…NTSB DEN86FA023Accident · Serious injuriesField investigationFinal reportBeech A45 · Albuquerque, NMWhile maneuvering to enter traffic at alameda arpt, the plt experienced severe acft vibrations. He attempted but was not able to reach the arpt due to rapid loss of airspeed andaltitude. The acft crashed 1/2 mile from the landing rwy. The one pax and a…NTSB LAX85FA214Accident · 1 fatalField investigationFinal reportBeech A45 · Fallbrook, CAThe plt was flying to his home arpt under visual flight rules (VFR) from his place of employment when he encountered low ceilings & visibilities. He contd at low alt along an interstate highway toward his original destination. A witness reported that the plt…NTSB CHI81PEE51Accident · No injuriesClosedBeech A45 · Glenview, ILNTSB DEN80FQA19Accident · Serious injuriesClosedBeech A-45 · Taos, NMNTSB FTW79FRA16Accident · No injuriesClosedPiper PA-31 · Houston, TXNTSB SEA79FYM21Accident · Serious injuriesClosedBeech A45 · Goldendale, WANTSB IAD78IA110Incident · No injuriesClosedBoeing 727 · Roanoke, VANTSB MIA78FA044Accident · 1 fatalClosedBeech A45 · Moultrie, GANTSB MIA78DKJ03Accident · No injuriesClosedBeech T34 · Headland, ALNTSB ANC76AA096Accident · 4 fatalClosedBeech A-45 · Summit Lake, AKNTSB IAD76II042Incident · No injuriesClosedDouglas DC-3C · Baltimore, MDNTSB FTW76AF029Accident · 1 fatalClosedBeech A45 · Houston, TXNTSB NYC75AN112Accident · 2 fatalClosedBeech A45 · Southport, CTNTSB FTW75AF067Accident · 4 fatalClosedBeech T-34A · Tomball, TXNTSB FTW75AF056Accident · 2 fatalClosedBeech T-34A · Granbury, TXNTSB OAK74FVA46Accident · Serious injuriesClosedBeech T-34 · Porterville, CANTSB CHI73FEA24Accident · Serious injuriesClosedBeech A45 · Muncie, INNTSB CHI73DEG01Accident · No injuriesClosedBeech A45 · Xenia, OHNTSB CHI71FLQ26Accident · No injuriesClosedBeech T-34A · Louisville, KYNTSB OAK70AP055Accident · 1 fatalClosedBeech T-34A · Mammoth Lakes, CANTSB NYC70DFD11Accident · No injuriesClosedBeech T-34 · Nantucket, MANTSB DEN70D0076Accident · Minor injuriesClosedBeech T-34A · Fort Bridger, WYNTSB MKC6.A0026Accident · 2 fatalClosedBeech T-34A · Glencoe, MNNTSB DEN69F0111Accident · Serious injuriesClosedBeech A45 · White Sands, NMNTSB FTW69F0123Accident · Serious injuriesClosedBeech T-34 · San Antonio, TXNTSB CHI69D0040Accident · No injuriesClosedBeech T-34A · Milwaukee, WINTSB NYC68F0330Accident · 1 fatalClosedBeech T-34 · Butler, PANTSB CHI68F0506Accident · No injuriesClosedBeech T-34A · Milwaukee, WINTSB DEN68F0068Accident · No injuriesClosedBeech T-34A · Albuquerque, NMNTSB MIA68F0030Accident · No injuriesClosedBeech A45 · Picayune, MSNTSB OAK68D0001Accident · No injuriesClosedBeech T-34 · Boulder City, CANTSB MIA67D0513Accident · No injuriesClosedBeech A45 · Hartsville, SCNTSB OAK67F0255Accident · Minor injuriesClosedBeech A45 · Camino, CA
Back to Beech A45