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 20020711036449ICessna R172K · Detroit/Grosse, MI(-23) On final approach the engine quit, after setting up for best glide, I attempted to restart & engine restarted for 10 seconds, I then ditched the aircraft 1500' short of runway 35 in the water.Accident 20020711032659ACessna 172N · West Milford, NJ(-23) Pilot stated he was high on approach with VASI white/white, flaps 10 degrees with 70-75KIAS, airspeed increasing when he pulled back on control wheel as mains touched runway. Aircraft bounced high and subsequently touched down in a nose low attitude…Incident 20020711024779IMooney M20M · Paducah, KY(-23) On July 11, 2002, at 08:49 CDT, a Mooney M20-M, N9151X, departed Paducah (pah), KY on an IFR flight plan. The pilot climbed through an assigned altitude of 4,000'. The pilot advised ATC he was having trouble with his instruments and that the autopilot…Incident 20020711022529IMooney M20M · New Braunfels, TX(-23) On July 11, 2002, while acting as pilot-in-command of a Mooney, N405CG, on a VFR flight from corpus christi, Texas to new brunfels, Texas, Mr. Jose garza, holder of private pilot certificate number 527082943, landed at the New Braunfels airport without…Accident 20020711021489ACessna 310R · Jackson, MI(.19) On July 11, 2002, at 1002 eastern daylight time, a Cessna 310R, N5061J, piloted by a commercial pilot, sustained substantial damage while landing on runway 6 (5,344 feet by 150 feet, dry/asphalt) at the Jackson county airport (jxn), Jackson, Michigan.…Incident 20020711018009ICessna 172N · Warrenton, VA(-23) Hit deer while shooting touch and go's at Warrenton airport, during take-off.Accident 20020711017379ACessna U206F · Koliganak, AK(-23) On July 11, 2002, about 1930 Alaska daylight time, a tundra tire-equipped Cessna U206F airplane, N696TK, sustained substantial damage during takeoff on a sandbar in the nushagak river, about 20 miles north of koliganek, Alaska. The airplane was being…Incident 20020711016999IBeech A36 · Farmington, NM(-23) On take-off, aircraft exited runway to the left. Both main gear doors struck runway lights, causing minor damage to aircraft and damaging runway lights. The aircraft came to rest in the grass alongside the runway.Accident 20020711016929AHughes 269A · Hamilton, AL(.19) On July 11, 2002, at 2100 central daylight time, a Hughes HU-269-A, N911LH, registered to and operated by the flight instructor, collided with the ground during autorotation, at the Marion co-fite airport in Hamilton, Alabama. The instructional flight…Incident 20020711016649IPiper PA32300 · Skagway, AK(-23) N31589, a PA-32-300, was idling @1000 RPM on the parking ramp at the Skagway Airport (pagy). The pilot, Mr. Donn e. mcginnis, became distracted by the overhead light in the cockpit. While attempting to turn off the overhead light the pilot allowed the…Accident 20020710038319ACessna 152 · Chelsea, MI(-23) Student pilot departed pontiac, MI (ptk) airport and performed practice maneuvers northwest of ptk. Upon returning to ptk pilot got lost and wandered southwest of ptk to area of jackson, MI. Pilot was in contact with ptk tower and was heading to howell,…Accident 20020710037689AUnivar 1082 · Lincoln Park, NJ(-23) On July 10, 2002, at 11:25, eastern daylight time, a Stinson 108-2, N390C, was substantially damaged when it struck a parked, YAK-55 aircraft. During an attempted takeoff from Lincoln Park Airport (N07), Lincoln Park, new jersey. The certificated…Incident 20020710027409IAMD Falcon · Omaha, NE(-23) N403JW, Amd-20, enroute from dallas, TX, to st. paul, MN, diverted to Omaha, NE. The pilot stated that during cruise the number two engine oil pressure fluctuated, and the low oil pressure warning light illuminated. The crew shut down the engine,…Incident 20020710027149ILear 55LEAR · Salina, KS(-23) The aircraft departed Salina, KS (sln) airport on runway 35. Flight crew said takeoff was normal except for a moderate dip in the runway. The pilots do not notice any problems with the takeoff roll, rotation, or gear retraction. A nearby aircraft on the…Incident 20020710022859ICamron A120 · Snohomish, WA(-23) Pilot was conducting an evening commercial sightseeing flight with six passengers. Pilot stated he conducted a thorough preflight weather review. After launch the surface wind increased considerably, instead of decreasing as the weather forecast…Incident 20020710020979IWthrly 620B · Jonesbore, AR(-23) On July 10, 2002, at 1438 CDT, a weatherly 620B, N9012P lost engine poewr after a turnaround maneuver. The pilot was forced to land in a rice field. The commercial pilot was not injured and the aircraft sustained minor damage. The aircraft was being…Accident 20020710019959ASkrsky S58ET · Brookville, IN(.19) On July 10, 2002, about 1615 eastern standard time, a sikorski S-58ET helicopter, N580US, piloted by a commercial pilot, was substantially damaged when it struck powerlines and subsequently impacted into Brookville lake, Brookville, Indiana. The…Accident 20020710019879ACessna 172N · Pickens, SC(-23) The pilot stated that during take off he realized he had failed to remove the control lock. He ran off the end of the runway causing substantial damage to the aircraft. (.19) on July 10, 2002, about 1133, eastern daylight time, a Cessna 172N, N737CQ,…Accident 20020710019509ACessna 150F · Fort Wayne, IN(.19) On July 10, 2002, about 1800 eastern standard time, a Cessna 150F, N8789S, piloted by a private pilot, sustained substantial damage during a forced landing after a loss of engine power during climb after takeoff from runway 34 (8,000 feet by 150 feet,…Accident 20020710018539AAmtr FOKKERDR1 · Portland, OR(-23) According to PIC and witness, after normal touchdown, during roll-out left main wheel separated from axle, a/c flipped over. Damage consisted of left wheel/axle, firewall and top wing leading edge spar damage.Incident 20020710015529ICessna 172S · Pittsburgh, PA(-23) At 1731E, N329ME, a CE-172, veered off the right side of runway during landing. As a result, the aircraft struck a sign and the left main gear was damaged. There were no injuries to the occupants.Incident 20020709035029IBeech 3533 · Lancaster, CA(-23) This instrument rated and current private pilot, selected the wrong lever and landed gear up as he tried to retract the flaps on landing, which he was practicing to prepare for high wind landings at wjf, which often has high winds. No other factors was…Incident 20020709029359ICleveland, OH(-23) [privacy data omitted]Incident 20020709027819ICessna 150J · Frederick Town, MO(-23) A flight instructor and student were on a dual cross country flight. The temperature was very hot and the density altitude was near 4,000'. The Cessna 150 did not climb quickly, and as a result, the flight instructor elected to fly at approximately…Incident 20020709018999IPilats PC1245 · Lynchburg, VA(-23) At 0300 local, on July 9, 2002, a Pilatus PC-12-45, N343CW, struck two deer on landing rollout at Lynchburg regional airport (lyh). The aircraft was piloted by steven a. walters (PIC) and michael zimmerman (SIC), both crewmember's held airline transport…Accident 20020709018429AAmtr Cosmosiii · Deer Park, WA(-23) Pilot initiated takeoff from runway 34. Full power was applied and a/c began to climb, then began a roll to the left. Bank angle continued to increase, a/c began to apparently "slip" sideways to contact with the ground. There was no indication, to…Accident 20020709016199ABeech 95B55 · Mesa, AZ(.19) On July 9, 2002, at 1914 mountain standard time, a Beech 95-B55, N812D, landed hard on runway 22L, and collapsed the right main landing gear at the Falcon Field Airport (ffz), Mesa, Arizona. The airplane was operated by Falcon executive aviation under…Incident 20020709013919ICurtis C46FFLYTIGER · Iliamna, AK(-23) [privacy data omitted] enroute 9K2 to ena when aircraft experienced no. 1 engine fire accompanied by both fire warning flight and bell. Fire was observed coming from the engine cowling. The engine throttle was pulled back and the fire went out and all…Accident 20020708027519ACessna 175 · Kaiser, MO(-23) On July 8, 2002, at approximately 2100 hours, Mr. William anderson, owner and pilot of N175HL, a Cessna 175, departed the lee c. fine airport located at Kaiser, MO. Enroute to peoria, IL. Shortly after take off Mr. Anderson experienced a rough engine…Incident 20020708027349IBoeing 737322 · Omaha, NE(-23) Male passenger was questioning a cabin crew member about his ticket and stood up next to his seat. Passenger was removed from the aircraft prior to taxiing from the gate.Accident 20020708021909ACessna 172B · Denton, TX(-23) On 07-08-02 at 11:30 a Cessna model 172B, registration number N7550X owned by maurice h. lundy whose [privacy data omitted] was involved in an accident. Mr. Lundy who was the pilot and Mr. Clifferd hardy the passenger left Denton Municipal Airport…Incident 20020708020849ICndair CL6002B19 · South Bend, IN(-23) Aircraft struck deer during landing rollout on RW26. The right flap was the only part of the a/c which received any damage. A SDR will be submitted.Incident 20020708020469IAirbus A310300 · Chicago, IL(-23) On Monday July 8, 2002, an inspector from the o'Hare flight standards district office (fdso) received a telephone call from the great lakes regional control center at 2115 hours. A royal jordanian airlines A-310 aircraft registration number jy-agl…Incident 20020708018869ILuscom 8A · Hubbard, OR(-23) According to PIC, he aborted the take off at 30 ft AGL due to no indicated airspeed. During resulting landing, the right main gear collapsed and a/c ground looped. Damage limited to rt wing tip and right main gear. Incident investigate revealed the no…Incident 20020708017969IDhav DHC8102 · Buffalo, NY(-23) After the gear was selected up the RH gear door amber light illuminated. The buf FAA tower dispatched the CFR vehicles however the crew did not declare an emergency. The aircraft returned to buf and landed on runway 23 and taxied to the ramp without…Accident 20020708017739ACessna U206F · Kodiak, AK(-23) The pilot was transporting passengers from the lower karluk river to larson bay strip. This flight is very short, less than 10 minutes. After completing several round trips, the pilot landed with the gear extended in the river. The aircraft contacted…Incident 20020708016419ICessna 172RG · Ruston, LA(-23) The instructor was distracted while giving instruction on take-off and landings and forgot to lower the landing gear.Incident 20020708016059IAmtr Q2 · Ebensburg, PA(-23) Loss of control during high speed taxi. No intent to fly. Aircraft reconfig from tail wheel to nose wheel. Informed NTSB, dave musio fss, com center. Reclassified to incident (industrial accident). Aircraft mms from isis is 05645WY mms not found in…Accident 20020708015669AAmtr ROTORWAY162F · Denver, CO(-23) Helicopter was cleared to air taxi to the compass rose by the tower. This route of flight required the helicopter to fly behind the signature building on the airport. Due to gusty wind conditions and changing wind directions, the flight path behind the…Incident 20020707037219IBeech D45 · Lemars, IA(-23) Flight was a local VFR pleasure flight from Lemars, IA (lrj) with the pilot and one passenger. While on final approach to runway 18 at lrj, the PIC selected the gear to the down position. While the gear was in transit, the aircraft experienced a total…Incident 20020707027369IBeech 95B55 · Wichita, KS(-23) Aircraft landed at Jabara airport, Wichita, KS. Upon touchdown the aircraft skidded to the right side of the runway. Midwest corp maintenance personnel retrieved the aircraft from the runway. They stated that the right tire was flat and was worn through…Incident 20020707023829ICessna 172N · Las Vegas, NV(-23) The pilot stated she was rolling out after a normal landing and the crosswind shifted 180 degrees. The aircraft departed the runway to the right and the nosegear collapsed as the aircraft hit the edge of the taxiway. The propeller and right wing tip hit…Incident 20020707022819IMooney M20K · Greeley, CO(-23) Pilot declared mayday while in the landing pattern at the Greeley airport due to fuel exhaustion on a VFR flight from las vegas. Pilot elected to land on the highway below rather than continue approach to the runway. Pilot added some fuel and departed…Incident 20020707022779IBalwks FIREFLY8B15 · Broomfield, CO(-23) Balloon was approaching jeffco airport airspace and pilot decided to land. Made steep approach to vacant building lots in subdivision. Wind was noted to be changing direction from southeast to east upon landing. Balloon touched down hard in a vacant lot…Incident 20020707022069IBoeing 747146 · Ontario, CA(-23) Kalitta air flight CK364, a B747-100 took off from Ontario airport, at about 0420 hours on July 7, 2002 for honolulu, hi and at about 30 minutes out declared an emergency, shut down #3 engine due to lack of hydraulic pressure and returned to Ontario…Incident 20020707021039ICessna 172P · Traverse City, MI(-23) Aircraft landing at tvc airport on runway 28, winds 230 degrees at 8 knots pilot stated gust of wind lifted aircraft at touch down damaging right wing tip and propeller. Aircraft damage minor and no injuries. CFI surveillance in accordance with order…Incident 20020707020479ICleveland, OH(-23) Passenger flores appeared to be intoxicated and failed to follow flight attendants instructions by leaving his seat on 2 occasions while the fasten seat belt sign was lighted.Accident 20020707017329ABell 47G2 · Compton, CA(-23) On 07-07-2002 at approximately 1250 PDT, a Bell 47G-2 helicopter (N2483B) experienced vibration and a loss of power which resulted in its autorotation to the ground and, striking of power lines at the 91 fwy and alameda ave, in Compton, California. The…Accident 20020707016869APiper PA18150 · Dillingham, AK(-23) On 7 July 2002, at approximately 17:00 hrs. Jeff charles puenta, private pilot #568353736, crashed super cub, PA-18-150, N91855, during step taxi after landing on king salmon river. He stated that somehow the left float dug in, or caught on something…Incident 20020707016269IRaven S60A · Glenwoodsprings, CO(-23) This was a 91 flight, had 4 friends on board, they flew for approx. 25 minutes, and landed they traded passengers, and took off again. The wind picked up and changed direction. The wind was blowing them toward a canyon. The pilot was concerned about…