FAA incident reports
234,323 FAA reports of aviation accidents and incidents, from the FAA’s Accident/Incident Data System (AIDS) through its Aviation Safety Information Portal. An incident falls short of an accident: a bird strike, say, or a gear-up landing without substantial damage. The NTSB investigates accidents separately, and its record of an accident is the fuller one.
Reports, newest first
Query with SQL
duckdb -csv -c "SELECT report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet' ORDER BY event_date DESC, report_number 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 report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet' ORDER BY event_date DESC, report_number DESC
Run 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.
Accident 20101230055219APiper PA-46-310P · Milaca, MNUpon arrival at the scene the aircraft was located approximately ¼ mile south of 150th avenue in a pasture area, the aircraft was oriented in an upright position with the right wing torn off laying between the aircraft and the initial point of impact. The…Incident 20101230054959ICessna 210B · Fullerton, CAAircraft on a normal approach for landing at ful. PIC indicated that all gear indications were normal. After landing the nose gear collapsed at touchdown.Incident 20101230054789IBoeing 757-351 · Colorado Spring, COIncident acft was operating as delta flight 1921 en route from detroit, Michigan to phoenix, Arizona (dtw-phx) at FL360 when they got an autothrottle disconnect message and noticed right engine epr at 1.0. Engine did not respond to throttle movement. Crew…Incident 20101230054229ISchweizer 269D · San Antonio, TXDuring cruise flight, the engine started to surge. Pilot did a precautionary landing on the highway.Incident 20101229055839IBoeing 757-223 · Jackson Hole, WYOn December 29, 2010 at approximately 1138 mountain standard time (MST) (UTC -7), a Boeing-757-223, registration N668AA, operated by American airlines, inc., as American airlines flight 2253 (aa 2253) failed to stop within the confines of the runway while…Incident 20101229055299IPiper PA-28R-201T · Sarasota, FLOn December 29, 2010, at approximately 1610 EDT, a Piper PA-28R-201T, N92GM, serial no. 28-7803263, registered to Cirrus avition inc, and operated by instructor pilot edward michael barros, had the nose landing gear (NLG) collapsed during landing causing the…Incident 20101229054879IPiper PA-28-181 · Prairie Du Sac, WIPilot stated on his turn from base to final he saw high tension power lines and brought the throttle back to idle and made a percautionary landing in the field below. There were no injuries or damage to the aircraft.Accident 20101229054839AEurocopter MBB-BK 117 · Mcas Cherry Pt, NCPilot departed pitt greenville hospital enroute to carteret hospital. At about 2000 feet and about 3-4 minutes from destination (12 miles south of nkt), pilot had the autopilot on and disengaged it. Shortly after disengaging the autopilot, pilot right arm…Incident 20101229054799IFlight Desi Ctsw · Lititz, PAAircraft performed normal approach to runway 31. After touchdown on the centerline, aircraft drifted to the left while on main gear wheels only. Pilot lost directional control of aircaft and aircraft departed runway pavement, continued and crossed taxiway…Accident 20101229054699ARockwell IN 114A · North Lima, OHPilot donald l hoover stated that upon landing on runway 28 at Elser Metro Airport (4G4), immediately upon touch-down at 75 - 80 KTS, the aircraft veered to the left and off the side of the runway. He said that it felt like the left wheel brake was locked or…Incident 20101229053779ICessna 152 · Rapid City, SDOn December 29, 2010 at 10:25 local time student pilot samuel hoeft lost control after landing at Rapid City regional airport. The aircraft left runway 14 and the aircraft struck a runway sign and bent one propeller blade, the nose landing gear and the lower…Incident 20101228055281IAirbus Indu A319-112 · Saint Louis, MOCaptain short initally believed his aircraft was to be deiced on the gate. He was directed to 'c' pad for deicing by ground metering. Upon arrival at "c" pad, four aircraft were waiting on or in the process of being deiced. There were no marshallers present,…Incident 20101228055209IMooney M20E · Charleston, SC12/28/10: Pilot dep lyh the gear would not retract. Pilot elected to continue to his destination and have maint look at it there. The pilot declared an emergency landing and the gear collapsed upon landing at chs. 1/5/11: gear inspection performed and…Incident 20101228054819IBoeing 737-3H4 · Baltimore, MDOn 12/28/2010 at 0630, N375SW was involved in an incident at bwi airport. During aircraft movement from the remote ramp at bwi to the gate the aircraft knocked over a provisioning truck during taxi. Swa had two mechanics on the ground and two mechanics taxing…Accident 20101228054689ACessna T210L · Abilene, TXInstrument rated private pilot was VFR enroute to etn (eastland TX) for a fuel stop with flight following and got an IFR clearance but missed the approach when his left fuel tank ran out of fuel. He accepted vectors back to abi (Abilene TX) but the right fuel…Incident 20101228054081IEmbraer-Emp ERJ 170-200 · Saint Louis, MOCaptain andrew d. mccombs had positioned his EMB-170 aircraft for deicing in the "c" pad at stl international airport. He reported feeling a slight bump as an aircraft taxied behind his spot in the deicing pad. The f/o, mohammad reze parham ranjbar…Incident 20101227055629IPollock Mic Velocity 17 · Sebastian, FLInitially landing gear would not extend declared emergency and was able to get get down to land.Accident 20101227054829ACessna 210B · Berthoud, COOn December 27, 2010, at 1436 mountain standard time, a Cessna C-210B airplane, N200EP, impacted terrain near carter lake, Loveland, Colorado. The airplane was destroyed and the pilot was fatally injured. Ptrs# NM03201103944AMENDMENT to followAccident 20101227054099AAero Comman 500-B · Columbus, OHWhile on a down wind approach to runway 27L at osu the pilot of N888CA declared an emergency. The aircraft descended sharply on the base leg hitting the ground on airport property, causing substantial damage to the aircraft.Incident 20101227053959ICessna 150F · Phoenix, AZPilot departed runway 25R at deer valley airport. After rotation the engine quit. The pilot landed on taxi way bravo and continued off he taxiway onto the airport perimeter road. While the pilot was holding short of the runway waiting for departure, there was…Incident 20101226055719IBoeing 737-401 · Windsor Locks, CTUs air flight 1023 B737 enroute Windsor Locks, CT to philadelphia reported a crack windsheld due to reasons unknown shortly after take off. Pilot reported that he would maitnain an altitude of 10, 00 ft and would continue on to destination. Mechanic at…Incident 20101226055089ICirrus Desi SR22 · San Jose, CAPilot landed hard on runway 13R, applied brakes hard, causing left wheel tire to blow. The aircraft was towed off the runway. No injury to sole occupant.Incident 20101226055079IBeech 200 · Salinas, CAPilot stated landing gear did not extend when gear handle moved to down position. Pilot stated he pumped the gear down using the emergency handle but did not get the green light down and lock indication. Both main landing gears collapsed on landing.Incident 20101226054919IPiper PA-18-150 · Chandler, AZPilot dave legas was conducting a VFR local traffic pattern flight. His first takeoff and landing was normal. His passenger was a pilot as well but was not current. He had flown with this pilot many times in the past. On the third downwind leg pilot legas…Incident 20101225054279IEmbraer EMB-145LR · Nashville, TNAfter completing the de-icing process, with both aircraft engines running, and after receiving both visual and radio communication from the de-icing crew indicating that de-icing was complete, the aircraft started moving forward toward the taxiway. At the…Accident 20101225054239ACessna 305A · Spooner, WIPilot set up a normal approach to an ice and snow covered lake. Upon touchdown, the pilot heard a loud noise and observed the left landing gear to be sticking out at a 90 degree angle to the fuselage. The pilot added power, taxied to a parking area, and came…Accident 20101225053939AAllen Raymo Lancair LEG · Troy, MIAircraft departed traverse city airport (ktvc), in traverse city, Michigan, on an instrument flight rules (IFR) flight plan to the Oakland Troy airport (kvll), in Troy, Michigan at 11:41AM local time. The pilot indicated that no icing had been reported with…Accident 20101224055979ABeech F35 · Syracuse, NYPilot was doing practice instrument approaches at Syracuse new york and asked ATC for clearance to climb into known icing conditions. Aircraft landed hard on runway 28 and experienced a collapsed nosegear. When investigators arrived the wings and windshield…Incident 20101224055269ICessna 172K · Bay St Louis, MSOn December 24, 2010 aircraft N79932 made a landing on runway 18 at Stennis International Airport in bay st. Louis without a nose landing gear wheel. During a student pilot solo cross country flight from Stennis International (khas), hattiesburg bobby chain…Incident 20101224055069IColumbia Ai LC41-550FG · Millsap, TXMr. Christie's airplane (N921DZ) was returned to service after maintenance on 12/22/10. Mr. Christie flew his aircraft from van bortel's at arlington, TX (where the maintenance was performed) to cleburne municipal airport for fuel and then on to his home…Incident 20101224053949IRoyse Ralph Glasair · Chico, CADuring approach to landing, the landing gear was extended. After the landing during approach to landing, the landing gear was extended. After the landing gear handle was placed down, the aircraft experienced electrical failure. The pilot was finally able to…Incident 20101224053739IBoeing 737-7H4 · Oaland, CAOn a flight from sfo to lax captain reported engine noise and fire warning. The captain made an engineering report on engineering log number 6345477 that stated: at appros. 1000AGL the engine popped - surged -vibration - master caution light and fire warning…Accident 20101224053689ACessna 140 · Winnsoro, SCOn December 24, 2010 at approximately 2:30 pm in a Cessna 140, N76831 loss control an roled over on it back during a normal landing at (kfdw) fairfeld county airport. Thomas truett stated " the aircraft was being flown by bob swisher, a current CFI, ATP…Incident 20101224053079ILindstrand 90A · Midvale, UTMr. Leake's family conducts a candy drop each year on December 24 with santa (son in-law). The flights are conducted under part 91 and no compensation is received. The pilot and his family incur the complete expense, and only family members are allowed in the…Accident 20101223055769ACessna 172S · Ft. Myers, FLDr. Krishnan was conducting the eighth touch and go on runway 05. He applied full power for the takeoff off phase and began to lose control of the airplane. He initially thought that "a wind gust" caused him to lose control of the airplane, although the tower…Accident 20101223054719APiper PA-18-150 · Anderson, AKPtrs # AL201101131MARK keech was involved in an accident with his personal aircraft 18 miles west of clear Alaska. Mr. Keech had just spent 5 days trapping and flying in the lake minchumina area. He filled his fuel tanks from jugs and said he filtered the…Accident 20101223054289ACommander A 114-B · Lander, WYOn December 23, 2010, N799RS, an aero-Commander 114, impacted high altitude terrain near Lander, WY. The flight was being conducted under 14CFR part 91. The actual time of impact is unknown, however weather reports indicate visual meteorological conditions…Accident 20101223054019ASchaefer AN Kitfox -4 · Glendale, AZPilot took off from runway 1 at geu. Witnesses reported the aircraft went right wing down and then crashed into the ground adjacent to the 2000' mark near a water retention basin on the airport grounds. Impact marks show the right wing contacted the ground…Accident 20101222055989AMooney M20R · Barrington, NYOn December 22, 2010, at approximately 2145 local time, FAA inspector [privacy data omitted] arrived at the scene of an accident involving a Mooney M20 aircraft bearing registration N968SM. The aircraft impacted terrain in a wooded area just off a logging…Accident 20101222055489APiper PA-31-350 · St. Michael, AKPilot landed on snow covered runway. Nose wheel tire went flat and directional control of aircraft was lost. Aircraft departed runway side and turned approximately ninety degrees to runway heading. Damage to nose gear, propellers, wing spar. No injuries.Accident 20101222054739ABeech C24R · Wheeling, ILJust after lift off from runway 34 at the Chicago Executive Airport (kpwk) the pilot reported to the control tower that he was experiencing vibrations and loss of engine power, and was returning to the airport. The aircraft then struck the roof of a building,…Accident 20101222054729AMooney M20E · Colorado Spring, COPilot was cleared for the ILS 17L approach to Colorado Springs airport. The weather was IMC. The last communication was that the pilot was going around. Contact was lost at this point and a ground search located the aircraft 400 feet east of the runway…Accident 20101222054669APiper PA-28-151 · Spencer, MAExamination of the aircraft and accident scene, showed that there was no evidence that the aircraft contained adequate fuel for its intended flight.Accident 20101222054639ARobinson He R44 II · Hemphill, TXOn 12/22/2010 at approx 2000 UTC helicopter N841SA, a Robinson R-44 ii with two persons aboard attempted to hover prior to takeoff from the shoreline of a lake. During hover immediately after liftoff, the aircraft turned violently to the right. This spinning…Accident 20101222054389AApollo Airc Delta JET A · Poipu, HIPoipu, HI :a delta jet, special light sport, weight shift control aircraft made a precautionary landing on a golf course subsequently the aircraft skidded and rolled over onto it's left side causing substantial damage to the left wing.December 28 hnl FSDO…Accident 20101222053679AMoyes/Baile Dragonfly B · St. Paul, ORThe pilot took off at approx 14:30 from sportsman airpark (2S6), newberg, OR, to south in an open-air cocpit, experimental light-sport aircraft (elsa), headed to lenhardt airpark (7S9), hubbard, OR. After leveling off at 1500 ft, the pilot let go of the…Incident 20101221055759IIkarus C42 · Venice, FLThe pattern was a little lower than normal, although the final approach was normal. Mr. Klement's stated that the touchdown on the left main gear was slightly harder than normal. During the rollout, he felt the airplane lean to the left, and he taxied off the…Incident 20101221055529IPiper PA-28-161 · Valkaria, FLAn aircraft assigned to fit aviation in melbourne on an instruction flight with two students were performing touch and go landings at the Valkaria airport. During one of the full stop landings, the students repositioned for further instruction. When…Accident 20101221054679ACessna 182P · Clifton, TXOn December 21, 2010 at approximately 10:20 local time, a 1971 Cessna, CE-182P aircraft, N9317G, owned by pauls valley flyboys, lls, departed the runway during the landing phase of a crosswind landing at Clifton municipal/Isenhower field airport, Clifton…Accident 20101221053669ACessna 340A · Madison, WIOn December 21, 2010 at 12:45 CT on approach to runway 18 Madison WI the pilot of Cessna 340A, N233DS, experienced windshield icing and lost visual contact with the runway. The aircraft went off the runway and substained substantial damage. The pilot, sole…