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 ('5870202')
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 ('5870202')
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 ERA13LA391Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Mitchellville, MDThe pilot’s failure to ensure that the wing flaps were properly configured before takeoff.NTSB LAX02LA271Accident · No injuriesLimited investigationFinal reportMooney M20 · Sierraville, CAthe pilot's decision to attempt takeoff in crosswind conditions that likely exceeded the capability of the airplane, and, his subsequent failure to maintain the airplane's proper alignment over the runway. Also causal was the pilot's premature liftoff and…NTSB MIA02LA027Accident · 2 fatalLimited investigationFinal reportMooney M-20-20 · Hilton Head, SCThe pilot's continued visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control, an uncontrolled descent, and an impact with the water.NTSB FTW00LA255Accident · No injuriesLimited investigationFinal reportMooney M20 · Owasso, OKThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW98LA082Accident · No injuriesLimited investigationFinal reportMooney M20 · Pocahontas, ARfailure of the pilot to maintain directional control of the airplane during the takeoff roll, which resulted in an inadvertent ground swerve. A related factor was: the pilot's lack of recent experience in the make and model of airplane.NTSB LAX98FA039Accident · 2 fatalField investigationFinal reportMooney M20 · Big Bear, CAVFR flight by the pilot into instrument meteorological conditions (VMC), which led to spatial disorientation, loss of aircraft control, and an uncontrolled descent into terrain. Related factors were: the adverse weather conditions, the pilot's lack of…NTSB CHI89DEM08Accident · No injuriesFinal reportMooney M20 · West Branch, MIThe pilot's decision to hand prop the engine with a non-pilot at the controls and the passenger's application to full throttle. A factor related to the accident was panic of the passenger.NTSB DEN88FA115Accident · 3 fatalField investigationFinal reportMooney M20 · Jamestown, COThe plt told a friend that he was going to conduct a sightseeing flt in the local area. Residents of a small town 2 miles from the acdt site said the acft circled the town at low alt several times at about the time of the accident. There were no witnesses to…NTSB FTW87LA207Accident · Minor injuriesLimited investigationFinal reportMooney M20 · Livingston, TXDrg a practice touch-&-go lndg, the acft bounced. The plt applied power to abort the lndg, but lost directional control of the acft. It drifted left toward trees, so he initiated a climb to fly over the obstructions. However, the acft stalled & collided with…NTSB CHI87LA213Accident · No injuriesLimited investigationFinal reportMooney 20K · Crestwood, ILUpon arrival at howell airport the pilot set up a close approach for landing on runway 36 because of deteriorating weather conditions. The pilot was unable to get current wind conditions at the airport from UNICOM but decided to continue the approach. During…NTSB SEA87LA133Accident · No injuriesLimited investigationFinal reportMooney M-20 · Spokane, WAAt touchdown a prop strike occurred. The pilot immediatley added full power to go around. Since the prop strike was severe full power was not available. The pilot made a shallow 180 degree turn back to the rwy and landed on the grass. During the landing…NTSB DEN86LA145Accident · No injuriesLimited investigationFinal reportMooney M20 · Fargo, NDThe plt reports that he experienced difficulty in retracting the landing gear after departure but it did retract after several attempts. He said the gear system seemed to be hanging up. Upon reaching destination the gear again seemed to hang up when extension…NTSB FTW85FPA03Accident · No injuriesFinal reportMooney M20 · Fort Worth, TXThe acft contacted an iron pole and a hangar following a loss of directional control during landing roll. The plt reported that after an aprx 300 ft ground roll, the acft veered left. The left wing contacted an iron pole which resulted in the acft rotating…NTSB DEN83LA223Accident · No injuriesLimited investigationFinal reportMooney M-2O · Rock Spring, WYThe acft landed with the landing gear up after the flt experienced some delays in landing because an airshow was in progress. The accident plt was told to hold 30 minutes and then 6 minutes later was told he could land if he hurried and'got back to the arpt…NTSB SEA83FA095Accident · 1 fatalField investigationFinal reportMooney M20 · Edmonds, WAThe plt had earlier visited his fiancee. She stated that he was intoxicated & she gave back her engagement ring to him. He was later observed departing the arpt. Shortly thereafter police began receiving complaints of a low flying acft overthe beach area. The…NTSB FTW81DQA30Accident · No injuriesClosedMooney M20 · Farmington, NMNTSB SEA81FYM19Accident · Minor injuriesClosedMooney M20 · Salem, ORNTSB CHI80FER54Accident · No injuriesClosedMooney M20 · Blaine, MNNTSB LAX78FA072Accident · 2 fatalClosedMooney M20 · Los Angeles, CANTSB MKC78FCA32Accident · No injuriesClosedMooney M20 · Lewistown, MONTSB FTW78DRG26Accident · No injuriesClosedMooney M20 · Smiley, TXNTSB LAX78FUD01Accident · Minor injuriesClosedMooney M20 · Compton, CANTSB MKC77FCG42Accident · No injuriesClosedMooney M20A · Independence, MONTSB FTW77FA064Accident · 1 fatalClosedMooney M20 · Shelbyville, TXNTSB NYC77FGT09Accident · Minor injuriesClosedMooney M20 · Kirkwood, PANTSB IAD77FHD05Accident · Serious injuriesClosedMooney 20 · Dover, DENTSB CHI77DEP01Accident · No injuriesClosedMooney M20 · Franklin, WINTSB DEN76AD054Accident · 2 fatalClosedMooney M20 · Cody, WYNTSB MIA76FLD47Accident · No injuriesClosedMooney M20 · Merritt Island, FLNTSB LAX75DUJ93Accident · No injuriesClosedMooney M20 · Chambers, AZNTSB IAD7KFHD49Accident · Serious injuriesClosedMooney M20 · Garrison Lake, DENTSB FTW75DRG21Accident · No injuriesClosedMooney M20 · Bandera, TXNTSB FTW74DRG89Accident · No injuriesClosedMooney M20 · Falcon, TXNTSB NYC74FNE14Accident · Serious injuriesClosedMooney M20 · Easthampton, MANTSB LAX74AL041Accident · 3 fatalClosedMooney M-20 · Fillmore, CANTSB CHI74FEG11Accident · No injuriesClosedMooney M20 · Miamisburg, OHNTSB NYC74FEM08Accident · Serious injuriesClosedMooney M20 · Dubois, PANTSB MKC73DTK05Accident · No injuriesClosedMooney MK20 · Pierre, SDNTSB CHI72DEP17Accident · No injuriesClosedMooney M20 · Hayward, WINTSB OAK72FXQ11Accident · Serious injuriesClosedMooney M-20 · Lee Vining, CANTSB MIA72AM018Accident · 3 fatalClosedMooney M20 · Ashland, MSNTSB CHI69D0646Accident · No injuriesClosedMooney M-20 · Carthage, ILNTSB FTW69A0032Accident · 1 fatalClosedMooney M20 · Wayne, OKNTSB MIA69D0199Accident · No injuriesClosedMooney M20A · Headland, ALNTSB CHI69D0171Accident · No injuriesClosedMooney M20 · Lyndon Sta, WINTSB MKC69D0020Accident · No injuriesClosedMooney M20E · Bottineau, NDNTSB FTW68A0078Accident · 4 fatalClosedMooney M20 · Page, OKNTSB LAX68D0139Accident · No injuriesClosedMooney M20 · Santee, CANTSB LAX68D0008Accident · No injuriesClosedMooney M20 · Santee, CANTSB CHI68F0293Accident · No injuriesClosedMooney M20 · Richton Park, IL
Back to Mooney M20