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 ('1152922')
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 ('1152922')
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 CEN23LA406Accident · Serious injuriesClass 4 · LimitedFinal reportBeech B200 · Elk Grove Village, ILThe pilot’s improper fuel planning, that resulted in a total loss of engine power due to fuel exhaustion, and a subsequent forced landing. Also causal was the pilot’s decision to go around with minimum fuel.NTSB CEN23FA113Accident · 5 fatalClass 3 · FieldFinal reportBeech B200 · Little Rock, ARThe loss of control during initial climb for undetermined reasons. Contributing to the accident were the sudden wind shifts during the initial climb.NTSB CEN22LA166Accident · Serious injuriesClass 4 · LimitedFinal reportBeech B200 · Odessa, TXThe airplane’s encounter with severe clear air turbulence that was not forecasted, which resulted in a serious injury to an unrestrained passenger.NTSB CEN20FA093Accident · 3 fatalClass 3 · FieldFinal reportBeech 200 · Coleman, TXThe pilot’s loss of airplane control due to spatial disorientation. Contributing to the accident was the pilot’s distraction with a “popped” circuit breaker and communications with air traffic control.NTSB CEN20LA084Accident · No injuriesClass 3 · LimitedFinal reportBeech 200 · St Louis, MOThe pilot’s loss of directional control and the subsequent nose landing gear collapse of for undetermined reasons.NTSB GAA18CA528Accident · No injuriesData collectionFinal reportBeech 200 · Burbank, CAThe flight instructor's and pilot receiving instruction's failure to maintain clearance from a tree while taxiing.NTSB ERA16CA302Accident · No injuriesData collectionFinal reportBeech B200 · Burnsville, NCA collision with a bush during landing.NTSB GAA16CA348Accident · No injuriesData collectionFinal reportBeech B200 · Carolina, PRThe pilot's failure to actuate the parking brake prior to leaving his seat, resulting in substantial damage.NTSB CEN16LA076Accident · No injuriesLimited investigationFinal reportBeech 200 · Gary, INThe pilot's failure to maintain the glidepath and appropriate airspeed during landing in icing conditions, which resulted in an aerodynamic stall and a hard landing.NTSB CEN11CA387Accident · No injuriesData collectionFinal reportBeech B200 · Waukegan, ILThe lightning strike during an en route descent.NTSB ANC11TA031Accident · Minor injuriesFinal reportBeech B200 · Atqasuk, AKThe pilot did not maintain sufficient airspeed during an instrument approach in icing conditions, which resulted in an aerodynamic stall and loss of control. Contributing to the accident were the pilot’s fatigue, the operator’s decision to initiate the flight…NTSB CEN10LA105Accident · No injuriesLimited investigationFinal reportBeech B200 · Sioux City, IAThe flight crew's decision to attempt a flight that was below takeoff, landing, and alternate airport weather minimums, which led to a touchdown off the runway surface by the pilot-in-command.NTSB LAX08CA151Accident · No injuriesData collectionFinal reportBeech B200 · Travis AFB, CAThe pilot inadvertently raised the landing gear during landing roll.NTSB OPS08IA004Incident · No injuriesIncident investigationFinal reportGulfstream American G5 · Teterboro, NJThe probable cause of this incident was the TEB tower local controller's failure to ensure that the runway was free of all known ground vehicles, equipment, and personnel before permitting a departing aircraft to start takeoff roll.NTSB DFW05LA031Accident · Minor injuriesLimited investigationFinal reportBeech B200 · Tulsa, OKThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight and in-flight planning / preparation.NTSB ATL04FA045Accident · 2 fatalField investigationFinal reportBeech B200 · Morlan, GAThe pilot's inadequate in-flight planning/decision when he continued the flight below the decision height and collided with trees. A related factor was the low ceiling.NTSB NYC01FA058Accident · 2 fatalField investigationFinal reportBeech B200 · Rangeley, METhe pilot-in-command's failure to maintain sufficient altitude while maneuvering to land, which resulted in a collision with terrain. Factors in the accident were the dark night, mountainous terrain, snow showers, clouds, and the pilot's decision to cancel…NTSB MIA00WA236Accident · No injuriesForeign investigationBeech B200 · Spanish Cay, BahamasNTSB LAX00LA203Accident · Minor injuriesLimited investigationFinal reportBeech B200 · Pacific Ocean (Pacific Ocean)Physical incapacitation of the pilot from improper handling of a pesticide.NTSB CHI99LA159Accident · No injuriesLimited investigationFinal reportAir Tractor AT-802A · Poplar Bluff, MOthe pilot selecting the wrong runway direction on which to initiate the takeoff and his failure to maintain directional control. Factors associated with the accident were the quartering tailwind condition, the rough terrain encountered, and fatigue.NTSB CHI97LA063Accident · No injuriesLimited investigationFinal reportBeech B200 · Marshall, MNthe pilot inadvertently putting the gear selector switch in the up position during landing.NTSB MIA96WA140Accident · 2 fatalForeign investigationBeech 200 · Treasure Cay, BahamasNTSB FTW96LA074Accident · No injuriesLimited investigationFinal reportBeech 200 · Ingleside, TXThe pilot's improper decision, while evading law enforcement personnel during an illegal/unauthorized operation.NTSB CHI94LA287Accident · No injuriesLimited investigationFinal reportHughes 369HS · Custer, SDthe pilot's selection of unsuitable terrain on which to perform an autorotation. A factor in this accident was the hidden obstruction.NTSB CHI88MA026Accident · 8 fatalMajor investigationFinal reportBeech 200 · Jefferson, WIWhile cruising abv frzg lvl at 12,000', the flt was clrd to dscnd & maint 9000'. Abt 1-1/2 min ltr, the flt declared a mayday (emergency). Radio & radar ctc were lost & the acft crashed in a nr vertical dscnt. Radar data showed that after starting a dscnt,…NTSB SEA87FA141Accident · 4 fatalField investigationFinal reportBeech B200 · Crystal Bay, NVWhile on an instrument flight plan in IMC, the flight was cleared for an instrument approach to the south lake tahoe airport, the intended destination. The aircraft departed the initial approach fix on the published transition to the final approach course.…NTSB MKC87DCQ01Accident · 1 fatalFinal reportJames Olivier Quickie · Harper, KSA witness stated that he observed the aircraft in slow level flight at a low altitude. The a/c then pulled up in a steep right turn, then it descended to the ground. Examination of the wreckage found no pre-impact problems with engine or controls.NTSB NYC86FHA03Accident · No injuriesFinal reportThomas Pitts S-1T · Avoca, PADuring a ribbon cutting ceremony at the wilkes-barre/scranton air show, the acft had a temporary engine failure while inverted 20 feet above the terrain. The acft impacted on the rwy, slid 500 feet inverted, turned over and stopped upright.NTSB CHI83IA327Incident · No injuriesIncident investigationFinal reportDouglas DC-8-71 · Chicago, ILOn landing roll the acft rolled forward off the departure end of the landing runway. The crew stated that maximum braking, revers, & spoilers were utilized. The runway was covered wth standing water.NTSB FTW82DA313Accident · No injuriesFinal reportBellanca 8KCAB · Alvin, TXThe pilot was making an approach to land in calm wind conditions. About 100 ft from the approach end of the runway, the aircraft stalled and crashed.NTSB MKC82DA053Accident · Minor injuriesFinal reportCessna 205 · Hebron, NEAfter landing on runway 30 the pilot stated that he initiated a turn to taxi to his parking space when a gust of wind lifted the tail of the aircraft into the air and it nosed over. Winds were gusting to 35 knots.NTSB MKC80FCD17Accident · No injuriesClosedBoeing A75 · Sioux City, IANTSB FTW77FPJ31Accident · No injuriesClosedCessna 337G · Oklahoma City, OKNTSB NYC73DID13Accident · No injuriesClosedCessa 170B · Portsmouth, VANTSB DIA68F0225Accident · No injuriesClosedCessna 170B · Newport News, VANTSB DEN68D0160Accident · No injuriesClosedBeech V35A · Clines Crns, NM
Back to Beech B200