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.
Incident 20130119001299IBombardier DHC-8-402 · Eugene, OROn January 19, 2013, at 1809 PST, during approach into Eugene (eug) 16R at approximately 200 feet AGL, aircraft had impact with large swan under first officers windscreen. Aircraft landed and taxied to gate without further incident. Inspection of the aircraft…Accident 20130119001169ABeech 95-B55 (T42A) · Mangum, OKAircraft was in a field in an upright position with three fatalities. There were no visible ground scars and wreckage was among small undamaged trees. Wreckage was damaged in a way consitant with a flat spin.Incident 20130119001119IPiper PA-23 · Statesboro, GAN2253P departed athens/ben epps airport(kahn) athens, Georgia enroute to Statesboro - bulloch county airport(ktbr) Statesboro, Georgia. The pilot stated that entering downwind at ktbr , he performed a gumpp procedure (gas , undercarriage , mixture , pumps ,…Incident 20130119001019INanchang China CJ-6A · Tuscaloosa, ALThe pilot failed to lower landing gear on approach. The airplane touched down approx 800 feet down the 4000 foot runway and slid approx 1150 feet. The propeller and both flaps were damaged but there was little structural damage to the aircraft.Accident 20130119000879ACessna 172F · Marysville, CADuring climb out from myv the engine lost power. The CFI made an emergency landing in a field off the airport. Upon touch down the aircraft flipped over.Incident 20130119000499IGlobe GC-1B · Payson, AZUpon landing the aircraft swung hard to the left. The loop causing the left main landing gear to collapse. The aircraft then settled on the left wing aileron hinges and slide to a stop. One tip of the propeller made contact with the runway surface causing…Incident 20130119000309IBeech A23 · Crystal River, FLThe pilot was attempting his first landing without another pilot in the aircraft familiar with this model. He had just purchased the aircraft on the morning of the incident. This was also his first night landing in this type aircraft. Upon his landing at the…Accident 20130119000289ACessna 140 · Boulder, UTOn January 20, 2013, the local pilot and friend were maneuvering the Cessna 140, N2341N, over the calf creek waterfalls in the valley at a high rate of speed. The pilot allowed the aircraft to drift over ut hwy 12 ,78.2 mile marker, at saddle ridgeline, the…Incident 20130118002179IMcdonnell Douglas Helicopter 369E · Lawrenceville, GAApproximately 15 minutes into the flight, the pilot noticed torque fluctuations. At approx. 20 minutes into flight,the pilot noticed increased N2 fluctuations. At this point the pilot diverted to the closest airport, Klzu. Approx. 2MILES from the airport the…Accident 20130118001799ACessna 150J · Tulare, CAThe pilot departed the porterville municipal airport at approximately 0830 local time to make the flight from porterville (kptv) to hayward (khwd) to madera (kmae) and back to kptv. The pilot had called his instructor to obtain the cross country endorsement…Incident 20130118001779IBell 430 · Kahului, HIAfter encountering turbulence at mcgregor point (maui) on the way to lanai airport (hwaii) the auto pilot disengaged and the pilot lost airspeed light and other instrument lights. After the pilot took over the control of the aircraft, he found himself in a…Accident 20130118001059APiper PA-28-235 · Rock Springs, WYOn 01/18/2013 at approx 1254 LCL N49DS, a pa 28-235 sustained substantial damage while landing at Rock Springs, WY (rks) one sole on board no injuries. Day VFR conditions prevailed.Incident 20130118000479IPiper PA-31P · Charlevoix, MIPilot approached Charlevoix (cvx) airport under IFR flight plan, pilot reported in statement that he was on GPS approach to runway 9, descending to 2300 ft to dunac picked up the glideslope to the runway, the ground became visible through broken clouds and…Incident 20130117002079IRobinson Helicopter R22 Beta · San Marcos, TXThe instructional flight was on a training approach to San Marcos (hyi) when the engine manifold pressure began to climb. The instructor PIC took over control of the aircraft when engine power was lost. A hard landing was made adjcent to the active runway.…Incident 20130117000559IPiper PA-28-180 · Oroville, CAWhile the Piper cherokee was climbing to cruise altitude of 10,000 feet, the engine began running rough then started to vibrate severely. Moments later the pilot heard a loud bang, subsequently releasing oil out of the cowling and onto the windshield. A…Accident 20130117000459ACessna 172RG · Redmond, ORThe left main gear leg failed to fully extend to a down & locked position when gear was lowered after several successful touch & go's at bend (S07). Pilot declared an emergency then landed gear up at Redmond (rdm) and both occupants safely egressed the…Accident 20130117000409ARobinson Helicopter R22 Beta · Ellington, CTOn Thursday January 17, 2013 at approximately 12:45 pm eastern standard time a student pilot and flight instructor operating a single engine rotorcraft Robinson model R-22 beta serial number 2353 crash landed to the north on runway number 01 at Ellington…Incident 20130117000269IRaytheon 390 · Reno, NVDuring the landing sequence, the landing gear handle was placed in the down position but no reaction occurred. Pilot stated he pulled the landing gear circuit breaker then manually lowered the landing gear. The circuit breaker was reengaged but the landing…Accident 20130117000239APiper PA-24-250 · Phillipsburg, OHDuring engine start the aircraft's engine produced power causing the aircraft to move rapidly. The parking brake was not set, and the aircraft impacted a hanger. Reviewed by dws, 01-23-2013Incident 20130116001769IBombardier CL-600-2C10 · Chicago, ILAt 1510Z eagle flight 3720 (egf) advised ATC of injuries on board due to severe turbulence at FL310 30SW of groov intersection. Egf flight 3720 declared a medical emergency and was given priority handling for a landing on runway 28 at o'hare international…Incident 20130116001701IBeech C-99 · Phoenix, AZOn 01/16/2013 a Cessna 402, N510NE, was relocated from the Phoenix Sky Harbor cutter, inc. tarmac to the adjacent cargo area loading ramp for the purpose of loading the aircraft. During ground movement, the right brake failed and the pilot attempted to slow…Accident 20130116001049APilatus PC-12/45 · Burlington, NCPilot departed buy on an IFR flight plan. During climb-out before being radar identified the pilot apparently lost control of the aircraft and crashed.Incident 20130116000979IColumbia Aircraft Mfg LC41-550FG · Colorado Spring, COOn 01/16/2013 at approximately 1400 hrs. MST, N2535X a Columbia Aircraft Mfg. Model LC41-550FG aircraft sustained unknown structural damage following a hard landing at Colorado Springs municipal (kcos) airport, CO. There were no injuries to the two occupants…Incident 20130116000959IAeromot AMT-200(Supr Ximngo) · Crestview, FLPilot stated he was enroute from 7FL6 to Texas when heavy head winds caused the aircraft airspeed to drop to 85 KTS. Pilot elected to land at cew due to deteriating weather conditions. Pilot stated as weather conditions worsened, he spotted runway between the…Incident 20130115025799IAeronca 7AC · Norridgewock, MEStudent on solo flight had landed on runway with intention of making full stop landing. After touchdown with tailwheel, pilot experienced what felt like violent shaking. Aircraft slowly began to turn towards the right side of runway where is struck a high…Incident 20130115000589IPilatus PC-12/45 · Hammond, LAUpon touchdown, while decelerating for a left turnoff at the end of runway,when applying reverse thrust and wheel brakes, no deceleration occurred. Pilot opted to exit the runway straight ahead off the end of the runway.Accident 20130115000469ACessna 208B · Pellston, MIOn January 15, 2013 a Cessna caravan 208B, N1120N, was destroyed after takeoff from Pellston, MI airport (pln). The airplane was operated by martinaire, under the provisions of 14 code of federal regulations part 135 on demand cargo with a VFR flight plan on…Incident 20130115000429ID & K Baby Belle · Hammond, LADuring aircraft run-up, ground crew (helper) approached aircraft from the rear, while engine was running and operating at idle. Main & tail rotor was turning. Ground crew while walking towards front of aircraft, had head lowered to avoid contact with main…Accident 20130115000089AAviat A-1C-180 · Upper Sandusky, OHDuring the landing rollout, the pilot experienced a gust of wind that initiated a ground loop event that the pilot could not recover from.Incident 20130114001129IBell 206-L4 · Sunrise, FLOn Monday, January 14, 2013, [privacy data omitted], pilot in command (PIC), was conducting a patrol flight which originated at marathon airport (mth), monroe county FL. To the ft. lauderdale executive airport (fxe), broward county FL. The aircraft departed…Accident 20130114000659ACirrus Design SR22 · Torrance, CAUpon landing at Torrance airport, during touchdown the propeller contacted the runway which damaged the propeller and the nose wheel. In the process of stopping, the aircraft veered off the runway and came to rest in the grass.Incident 20130114000649IScaled Composites 151 · Mojave, CAPilot was conducting flight test duties and became distracted on approach to runway. Factors were a modified (abbreviated) approach pattern and possible conflicting traffic. Operator is conducting internal investigation to develop procedures to preclude gear…Incident 20130113001929ICessna 560XL · Peachtree City, GAClimbing out of FL350 in known icing (-23C, 1000 feet per minute, autopilot engaged, wing/engine anti-ice on), the aircraft suddenly pitched nose down. Upon detecting the pitch change the autopilot was disengaged. The controls were difficult to move along the…Incident 20130113001279IDavis James L Lancair 320 · Fayetteville, NCGear up landing. Nose gear failed to deploy prior to landing at Fay.Accident 20130113001229APiper PA-28R-200 · Dover, DEPilot departed orz en-route to evy but changed destination to sby. Pilot attempted to land at sby but could not due to weather, then changed destination to ged. Pilot then attempted to land at ged but missed. He then diverted to 33N but was not able to…Incident 20130113000869IBellanca 17-31 · Banning, CABanning, CA (bng): N7357V, Bellanca 17-31, landed gear up at Banning arpt at aprx 131441PST. Injuries: none, damage: minor. (Ral FSDO, ntsb/hogenson) 1/13 2303ZIncident 20130113000549IMooney M20J · Napa, CAAttempted landing at the Napa county airport, CA (apc). Aircraft touched down too FAR down the runway to stop the aircraft within the runway remaining. The aircraft rolled off the end of the runway and came to a stop approximately 300' off the departure end…Accident 20130113000449APiper PA-34-200T · Manteo, NCThese facts are based on several eye witness reports from the ground, one of which was a pilot who had shot the same approach prior to the accident aircraft. These facts are also based on the eye witness statement of the survivor. Aircraft departed tta…Incident 20130113000219ICessna 560 · Palm Springs, CAPalm Springs, CA (psp): redlake 470, C560, crp-psp, declared an emergency 4 miles northeast of psp due to #2 engine failure and landed runway 31L safely at 131828PST. Aircraft exited onto taxiway juliet, shut down while ARFF units inspected #2 engine,…Accident 20130112002899APiper PA46-500TP · Paris, TXAircraft departed Cox Field (Paris TX) at 0850 hrs. Aircraft altitude was 5K and just received clearance to climb to 16K at 0900 hrs. After clearance, ATC reported lost aircraft on radar and no other radio transmissions. State police found the reckage about…Accident 20130112002199ABenton Fred D Seawind 3000 · Sarasota, FLOn January 12, 2013, about 1529 eastern standard time, a Benton seawind 3000, N829GS, was destroyed Following a collision with trees and terrain after takeoff from Sarasota/bradenton international airport (Srq), Sarasota, Florida. The commercial pilot and one…Accident 20130112000919APiper PA-28R-180 · Winder, GAOn January 12, 2013 at 1500 local approximately, aircraft N3898T a Piper PA-28R serial number 28R 30228 experienced a rough running engine and subsequent failure. The engine failure occurred when the pilot selected the fuel selector to the fullest tank in…Incident 20130112000519IMooney M20J · San Carlos, CAOn January 12, 2013 at approximately 1100 aircraft N100NY was attempting to land on runway 12, San Carlos airport, San Carlos, CA. Pilot was directed to extend his downwind leg by sql ATCT at which time pilot stated he was distracted with the ATCT…Incident 20130112000389ICzech Sport Piper Sport · Fernandina, FLFollowing take off at approxamately 500 ft, canopy came open. Pilot made emergency landing and went off runwayIncident 20130112000209ICessna 172 · San Angelo, TXOn January 12, 2013, at approximately 10:30 CST, the pilot and two passengers departed on runway 36, at San Angelo Regional Airport (sjt), in a Cessna 172, regisration number N5956A. Immediately after takeoff the engine began to lose power and the RPM was…Accident 20130111002189ACessna T182 · Valrico, FLDuring the climb through approximately 3,000 feet the aircraft Began to shutter and vibrate violently. Oil immediately coated the windscreen making forward Visibility difficult. Pilot located a field and crash landed the aircraft. No injuries.Accident 20130111000989ARaytheon 58 · Maxwell, NEAt approximately 15:48 local time aircraft departed IFR from north platte regional airport (lbf) in IMC conditions. Weather at that time was reporting overcast skies, variable between 600 to 1,100 feet, 3 miles visibility with light freezing rain. Temperature…Accident 20130111000439AAmerican General Acft AG5B · Ankeny, IAThe pilot purchased a grummin tiger in Florida and was flying it back to Iowa. He departed kcgi at 8:30PM CST enroute to kikv. When the pilot arrived at kikv there was a strong gusty wind reported as 220 at 17 knots gusting to 26 knots. The pilot attempted a…Accident 20130111000379ABeech 65-B80 · Alexandria, MNPilot on IFR flight plan from msp to axn decided to land on rwy 31 at axn with wind 190 @ 8 knots. Decision to land on 31 with a tailwind was made due to rwy 31 had an ILS approach and weather was reported to be 3/4 miles visibility and 200 ft. overcast. The…Accident 20130110000279AEric P Heinz Rans S-4 Coyote · Peoria, AZAfter doing a preflight inspection, pilot departed pleasant valley airport at approx 4:30 pm for a short flight to the north end of lake pleasant . The terrain surrounding the lake is montainous and rocky. Shortly after reaching cruising altitude pilot went…